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.

 

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