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.
CubeView will retain the Member filter assigned for the Account. The crude way is to mention the Accounts you want in the cubeview.
An alternate account hierarchy can be created with the desired accounts only and also creating a UD8 member with a Stored value in the formula where you call the accounts and exclude the unwanted account.
In cubeview Account member filter, you can also try the GetDataCell(ACC1+ACC2+.....):Name("MyAccounts")
This might again look like lengthy string but might get you the desired cubeview.
In the member filter, please try if you can get any output with the Where clause as well. I haven't tried it but will share feedback in case I test it.
Thanks for your comment. I'll have to try the first two suggestions. I did try GetDataCell but then I lose the drilldown functionality, unless I'm doing it wrong.
ChristianWOneStream Employee
You can add a drilldown path formula to the ud8 member.
