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

 

 

 

1 REPLY 1

JoakimK
New Contributor III

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

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