Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
3 months ago

Extensibility Question

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

 

 

 

  • 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.

     

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

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

    • vmanojrc30's avatar
      vmanojrc30
      Contributor

      For some reason the above didnt work for me. However  I used A#BALSHEET.Base.Options(ScenarioType = Flash) and that worked.

  • 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.