We are under construction!
You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.
Forum Discussion
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)
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.
