Skip to main content
S
sukensheth
Newcomer
November 9, 2023

Increase indentation for child members

  • November 9, 2023
  • 1 reply
  • 0 views

I am creating a cube view by defining "member.childrenInclusive" on the rows. Is there a way to increase indentation on the child members without defining each members on separate rows and specifying indent levels?

1 reply

C
cjohnson
Newcomer
November 9, 2023

Instead of .childreninclusive use .TreeDescendantsInclusive. This leaves the member hierarchy intact unless you have a .remove or custom member formula or something in there.

 

S
sukenshethAuthor
Newcomer
November 9, 2023

Yes, I used .TreeDescendantsInclusive but need more indentation on the descendants

R
rjgoss
Newcomer
November 10, 2023

How are you viewing the cube view?  In the Windows app, Excel or report/pdf?  Unfortunately, it doesn't seem to like putting IndentLevel as a conditional formatting property to view in the Windows app.  But it does work if you are viewing in Excel with something like the below.

The row will have (for examaple) A#Your_Member_Name_Here.ChildrenInclusive.

The conditional formatting would be:

If (MemberName <> 'Your_Member_Name_Here') Then
          ExcelIndentLevel = 5
End If

Not the most elegant solution if you have tons of rows or the member names on the rows are going to change often, but you could substitute parameters in for the hard coded members.  You'll have to weigh the effort versus the impact.

Terms & ConditionsAccessibility statement