Skip to Content
Mar 04, 2021 at 10:58 AM

Show account as flat presentation in table possible?

123 Views Last edit Mar 04, 2021 at 11:34 AM 3 rev

Hi experts!

I´m using a planning model with an account dimension using a hierarchy.

In the planning table I´d like to show filtered accounts as flat presentation, means a list of accounts without using the hierarchy. Unfortunately flat presentation is not available to select.

As possible workaround solutions is see

- duplication of account dimension without hierarchy

- duplicate all accounts in same dimension with formula referring to original account and don´t assign the duplicated accounts to the hierarchy

Both workarounds are not satisfiying.

Any other ideas?