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
Remove the value of a child
Is there a way that you can exclude the value of a specific child in the account hierarchy without losing drill down functionality in cube views? For example to exclude bonuses from staff costs.
You can create a dynamic calc (on the ud8 dimension) subtracting the members value from the nodes.
You can add a drilldown path formula to the ud8 member.
Thanks for the great tips. I can see the data at the detailed level but was hoping to get to a single row called Staff costs excl Bonus. Using the remove function is there a way to deduct a single account from the group to get a single line that sums all other account lines in the group without showing those account lines, or does this have to be done through GetDataCell where drill down functionality is lost?