CubeView rows: Remove member from Tree

Question

Hi all,I have a simple cube view where on the row I have Tree expansions, like the following one:UD5#MemberName.TreeThe reason I am using Tree instead of TreeDescendantsInclusive or others is because I want the rows to collapse on opening  and RowExpansionMode=CollapseAll only works with Tree for the first dimension of the row as far as I now.Now, the issue is that I would like to remove a member from the rows and the Remove does not seem to work on Tree, while it works on TreeDescendantsInclusive and others.U5#MemberName.Tree.Remove(U5#None) returns this (expansion enabled=yes, none removed=no):U5#MemberName.TreeDescendantsInclusive.Remove(U5#None) returns this (expansion enabled=no, none removed=yes):Is there a way for me to have both the ability to expand/collapse the rows and remove members from the hierarchy, or it is just a trade-off with the impossibility of having both at the same time? Thank you

T_Kress · Accepted Answer

I do not believe so.A work around may be to conditionally format the row with transparent text when the Member Name = 'None'.  Then it would not appear in the list but appear instead as a blank row.  You would also make the conditionally formatting a super small font row so the row is very tiny, and appears blank.Something like this:If (RowE1MemberName = 'None') Then     TextColor = Transparent,FontSize=6End IfJust an idea.But you are correct in that I do not believe .Remove works with .Tree and collapse all.

MarcusH · Answer

You have a syntax error. Remove U5# from the None member and that should work ieU5#MemberName.TreeDescendantsInclusive.Remove(None)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded