Increase indentation for child members
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...
Forum Discussion
Yes, I used .TreeDescendantsInclusive but need more indentation on the descendants
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.