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.
JackLacava
OneStream Employee
OneStream EmployeeYou 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.
Thanks, It was a long shot on the FXGet (My accounting grp loves them). Think now we are going split into two methods. Smaller reports (non-dynamic/licensed users) will use references back to fixed FXGet (we have an Excel guru who can build the logic) and for the more detailed reports go with the CV approach. This is one of those asks that I am not sure will be used that much but when your CFO gets excited about something, you find a way to deliver. Thanks.