Cube View indentation

fc
New Contributor III

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

fc_0-1711009958264.png

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!

3 REPLIES 3

tomdarnall
New Contributor III

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-dashbo....  This post shows how to build the hierarchy.

Hope this helps!

Tom

 

Tom Darnall, CPA
CFO Solutions LLC
Solution Architect

fc
New Contributor III

Thanks, I'll look into that!