Cube View indentation

Question

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&nbsp; (P&amp;L, BS etc.) through the parameter&nbsp;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.&nbsp;
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).&nbsp;Do you have any suggestion on how I could solve this?Thanks in advance!

tomdarnall · Answer

Do you have to have the Where? &nbsp;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. &nbsp;This will give you full control. &nbsp;This isn't exactly related, but I found this a few years ago, and it is handy&nbsp;https://community.onestreamsoftware.com/t5/Implementation-Q-A-Archive/Question-Can-I-create-a-dashboard-dropdown-or-list-box-which/ta-p/1335. &nbsp;This post shows how to build the hierarchy.
Hope this helps!
Tom
&nbsp;

JackLacava · Answer

Good idea, but there is a better approach: https://community.onestreamsoftware.com/t5/ONECommunity-Blog/Plant-a-Tree-in-your-Member-List/ba-p/22344

fc · Answer

Thanks, I'll look into that!

Forum Discussion

Cube View indentation

Related Content

Cube Views

Cube View Groups

Linked Cube View Refresh

Cube View Profiles

Cube view add dimensions to columns