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.
Forum Discussion
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.
Think its just the "." after remove that's causing the error
A#[Total Staff Costs].Tree.Remove(A#R7101002)
Cheers