Convert Hierarchy to Flat structure

[#1]

Hi Experts,

We have a requirement where we want to convert hierarchical structure to a flat structure. e.g. we have a hierarchy master data Org Unit. in transactional data we got a Org Unit A, now i want to have a attributes for this Org Unit which will show the layer of this Org Unit A. In this case if Org Unit is at level 3, then attributes will be Level1, Level2, Level3 and from top node till we navigate it should put values in level1, level2 & level3.

So my data is like

Org Unit Level1 Level2 Level3

A            B        C        A

Is it possible to get with existing data.

Regards,

Ganesh

[umashankar_poojar · Accepted solution]

Hi Ganesh,

         I didn't get requirement clearly, can you please give pictorial representation or with example at report/ in excel?

Thanks,

Umashankar

[Former Member · Accepted solution]

Hi UmaShankar,

Below is something which we are looking for Left Hand side shows hierarchy structure which we are converting to flat one.

Regards,

Ganesh