Skip to main content
V
vmanojrc30
September 25, 2024
Solved

Extensibility Question

  • September 25, 2024
  • 2 replies
  • 0 views

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

 

 

 

Best answer by SWilyums

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.

 

2 replies

J
JoakimK
September 26, 2024

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

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

V
vmanojrc30Author
October 21, 2024

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

S
SWilyumsAnswer
September 30, 2024

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.

 

Terms & ConditionsAccessibility statement