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
Query Parent member less a child vs. Alt rollups in a Dim *** Can you have a query that works ***
My CFO would like to be able to select a combination of children in our Department Dim and see our Net Income. Is there a way to dynamically calc that value. In the list below, he is asking if he c...
You have two options:
- Go full-Excel and do all the roll ups yourself, or
- Get out of your Excel comfort zone and start building Cube Views and advanced Member Filters - e.g. U3#TotalBu.Tree.Remove('IT'). These filters can then be driven by Parameters or other means (XFBR etc). Cube Views then get pulled into Excel.
In either case, you likely don't need a custom Dynamic Calc, they're not meant to allow user interaction with the formula.
Does he always want to exclude IT, or does it periodically change? it it's a consistent request, you could potentially load IT to a different U7 member. This could give you the ability to to toggle. Scratch this suggestion if the request inconsistent from period to period.