Create Hierarchies in a automatic way SAC

[Ganjos]

Hello everyone,

I have a question: is it possible to create hierarchies in SAP Analytics Cloud automatically from an Excel file?

For example, I have economic codes like D01.01.01 and D01.01.01.02, and I’d like to create a parent node called D01, and similarly for D02, etc. I’m currently doing this manually, but when the file has around 4000 lines, it becomes unmanageable.

Is there a way to create these hierarchies automatically in SAP Analytics Cloud?

Thanks in advance,
GAnjos

[William_Yu]

If the rule is simple as that, you may create an additional column from ID column and take leading 3 chars and map this column to parent node property through data wrangling.

[Ganjos]

Can you be more specific please?

[William_Yu]

check this help page: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/a8435da6970041d2beb32...

[Ganjos]

I can't open the link, it says "can't find the page"