Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Dimension Calculated Member Problem Expand / Collapse
Posted Tuesday, November 16, 2010 7:09 AM


Group: General Forum Members
Last Login: Thursday, February 18, 2016 7:13 AM
Points: 14, Visits: 446

Thanks you for looking at my post.

I have a Dimension as follows

- Category1
- Category2
- SegmentCode
- SegmentKey

which has Hierarchy called Category as follows

- Category1
- Category2
- SegmentCode

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.
Post #1021488
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse