Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 months ago

CubeView rows: Remove member from Tree

Hi all, I have a simple cube view where on the row I have Tree expansions, like the following one: UD5#MemberName.Tree The reason I am using Tree instead of TreeDescendantsInclusive or others is b...
Cube View
  • T_Kress's avatar
    T_Kress
    2 months ago

    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=6
    End If

    Just an idea.

    But you are correct in that I do not believe .Remove works with .Tree and collapse all.

MarcusH's avatar
MarcusH
Contributor III

You have a syntax error. Remove U5# from the None member and that should work ie

U5#MemberName.TreeDescendantsInclusive.Remove(None)

AndreaF's avatar
AndreaF
Contributor III
2 months ago

Hi MarcusH , the 2 expressions - U5#MemberName.TreeDescendantsInclusive.Remove(U5#None) and U5#MemberName.TreeDescendantsInclusive.Remove(None) - are equivalent, they both return the hierarchy with the None removed (I have just tested that just to be sure).