The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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.
3 Replies
JoakimKOneStream Employee
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.
