srinivas.sqlbidev (10/14/2015)
I know those are genuine duplicates , but users don't want to see those repetitions.There is one more column called SalesShipToCity that they need to have as member attribute.
So in that case SCOTT has 15 cities , in that case SCOTT name repeats 15 times.
Even though it is genuine repetitions but Users dont want to see same SCOTT 15 times.
Thanks
Srinivas
I have already suggested an approach to solve this issue and I don't see any additional questions above. Have you looked at your hierarchy in anything other than the browser in SSDT? It doesn't sound as if you have. The browser in SSDT is very literal whereas a presentation layer (Excel for example, even SSRS) is much more forgiving.