Hierarchy in New UX export

Hello,

When I do export a grid from anaplan in a .xlsx format I'm loosing the tabulations which distinguish my hierarchy levels. Is there a solution to get the correct display in my export ?

Here is what I have in anaplan:

And here is what I have in my excel export File:

Thanks,

Antoine

Accepted answers

M.Kierepka

Hi,

Tabulation is limited only to few levels, and there is no easy fix for that (both .xlsx and .xls share the same settings). So to distinguish levels:

All comments

KirillKuznetsov

@AntoineFedi

Hi Antonie,

One idea comes to my mind is to create a property "Name with Level" to apply L1-L7 suffix to the naming of the items in the hierarchy like this:

Site Saint-Loup (L1)

Bouvrat C.-130 (L2)

K3 MODUL (L3)

Allemagne - K3 MODUL (L4)

TAYLOR (L5)

S_TAYLOR (L6)

Then in export settings (Labels tab) select this property as your name label instead of the default one.

Also to imitate the shift you can add blank unicode symbol in front of the name “⠀” (https://www.google.com/search?q=blank+unicode+symbol&oq=blank+unicode+symbol&aqs=chrome..69i57j0i19i22i30l8.374j0j7&sourceid=chrome&ie=UTF-8)

But the main problem with this approach is that it applies only to the lowest level of hierarchy. And then you have two options: 1) make a duplicate of the hierarchy with nested levels in a single list, 2) use display name for each level of your hierarchy and a trigger which with a switcher to show shifted names or names with levels.

Otherwise you will have to go and rename each element in your hierechy to add a suffix L1-L7 to them permanently. After all said above, I think that if naming is not so strict in your case I would prefer to rename elements to add a suffix L1-L7 permanently.

M.Kierepka

Hi,

Tabulation is limited only to few levels, and there is no easy fix for that (both .xlsx and .xls share the same settings). So to distinguish levels:

KirillKuznetsov

@AntoineFedi

I am agree with @M.Kierepka

I think you should consider to remove total levels and replace them with labels from properties. This will be anyway better in excel plus users will be able to aggregate data using pivot in excel and bring the levels back.

AntoineFedi_*22568

Thank you for your answer

AntoineFedi_*22568

Thank you for your anwser

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…