Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 28, 2014 10:19 PM
Points: 14, Visits: 368
Hi,

Thanks you for looking at my post.

I have a Dimension as follows

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

Add to briefcase

Permissions Expand / Collapse