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. 

DeanHarper's avatar
DeanHarper
New Contributor II
4 years ago

Hi, You can use the remove function in the member filter eg

A#Staff_costs.tree.remove(A#Bonus_cost)

Managing Consultant - AMCO Solutions

  • 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.

    • DeanHarper's avatar
      DeanHarper
      New Contributor II
      4 years ago

      Think its just the "." after remove that's causing the error

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

      Cheers