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

CrispinC's avatar
CrispinC
New Contributor II
4 years ago
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.
Cube View
  • ChristianW's avatar
    ChristianW
    4 years ago

    You can create a dynamic calc (on the ud8 dimension) subtracting the members value from the nodes.

  • ChristianW's avatar
    ChristianW
    4 years ago

    You can add a drilldown path formula to the ud8 member. 

CrispinC's avatar
CrispinC
New Contributor II
4 years ago

Hi,

Thanks for your advice. I've tried to apply the member filter 

A#[Total Staff Costs].Tree.Remove.(A#R7101002)

with R7101002 being the bonus account.

However I get a result that says #ERROR - Unexpected Text.

I'm not sure how to get around this.

 

MarcR's avatar
MarcR
Contributor II
4 years ago

You should remove the . Before the bracket and the A# between the brackets. 
.remove(R7101002) when you hover over the examples in the member selection pane you often see the correct syntax.