Extensibility Question

vmanojrc30
Contributor

I have  a Summary & Detailed Account dimension. The Detailed Account dimension extends from Summary dimension.Ex

   Account Dimension
Cash  Summary
 A Detailed
 B Detailed
 C Detailed

I have a Cube where I have set the Cube dimension Properties of a Scenario to use the Summary Account dimension. I was able to load the data at Cash account level as shown above.

However when I retrieve the data with BalSheet.Base , OS still treats A,B,C as base member instead of Cash and show up no balances. When I specifically identify A#Cash I get the balances I loaded.

Is this expected behavior that OS doesn't treat "Cash" as Base member from Summary Account Dimension? If so is there a solution to retrieve the Cash account as Base.

Thanks

Manoj

 

 

 

2 REPLIES 2

JoakimK
Contributor

Not sure this is exactly what you are after, but it works. Try using this member filter:

A#BalSheet.Base.Where(MemberDim = SummaryDimensionName)

SWilyums
Contributor

Try this as you member selection.

A#BalSheet.Base.options(cube=|WFcube|, scenariotype=Budget, MergeMembersFromReferencedCubes=False)

You may have to update the cube and scenario type.  The scenario type identifies the dimension used.