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

[N1kh1l]

@Ganjos 

As William said, while loading the file, in data wrangling create a Parent ID column and then just take 3 characters from the left of the ID column. If you have sublevels like D01.01 as parent of D01.01.01.02 then you can use IF along with LENGTH() to check length and then either read 3 or 6 characters for parent column. But if its always D01 for all members starting with D01 then below should work.

Hope this helps !!

Nikhil

[Ganjos]

Hi, thanks for the answer @N1kh1l. I tried it, but when I used the formula, 'D.02' appeared instead of 'D.01'. I used the following instruction: [Parent]=substr([id],0,4). Initially, I wanted to create a hierarchy in the hierarchy section, and after importing the data, I was hoping to automate this process in some way. Is it possible? Thanks in advance, Ganjos