Thanks you for looking at my post.
I have a Dimension as follows
which has Hierarchy called Category as follows
My requirements are as follows
- Sort category1 by its members (i.e. FixedAssets, CurrentAssests, CurrentLiability)
I have created another column in the DSV called category1sort and used attributeName property. This solution works as expected.
- Create calculated member called NetAssets to allow excel users to the browse cube through using this member.
I have tried following tricks
- Kept isaggegatable property to true for Category1 member that makes all member available.
I created calculated member in the cube, choose Category as the parent hierarchy and all as a parent member. Now when I browse the cube using Category hierarchy, SSAS calculate right values for all the dimension members as well as NetAssets but I can not drilled down to category2 apart from first member in category1 level.
- If I remove all from parent member property for calculated member, everything works fine but calculated member does not appear as category1 members go under all member and calculated member go under members in hierarchy.
Any help would be great.