Cube View indentation

Forum|Forum|2 years ago
March 21, 2024
2 replies
0 views

Hi everybody,

I'm currently developing a dynamic CV that gives the chance to the user to select an account hierarchy of choice to show in the report (P&L, BS etc.) through the parameter MainFormParentAcc_PL

I'm having issues with indentation tho, because if I add .TreeDescendants the accounts are still shown on the same level in the report.

I tried to look if there is a format I can apply, but if I understand correctly the only format available for indentation is for the excel view (ExcelIndentLevel = xxx).
Do you have any suggestion on how I could solve this?

Thanks in advance!

Cube View

T

tomdarnall

Do you have to have the Where? If not, .Tree is the easiest, but it doesn't love being paired with a Where.

If you need the Where, one thing you may consider is using code to build your hierarchy. This will give you full control. This isn't exactly related, but I found this a few years ago, and it is handy https://community.onestreamsoftware.com/t5/Implementation-Q-A-Archive/Question-Can-I-create-a-dashboard-dropdown-or-list-box-which/ta-p/1335. This post shows how to build the hierarchy.

Hope this helps!

Tom