2 weeks ago
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 weeks ago
Not sure this is exactly what you are after, but it works. Try using this member filter:
A#BalSheet.Base.Where(MemberDim = SummaryDimensionName)
2 weeks ago
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.