transform hiearchy levels to navigational attributes
I want to transform hierarchy levels to navigational attributes.
Let's give an example.
I have 0costelmnt hierarchy with 5 levels.
When reporting in Bex, because of formatting problems, we need to show it without hierarchy.
I would like to have navigational attributes of 0costlmnt for each level.
Level 1 of 0costelmnt hierarchy = zcost_lv1
Level 2 of 0costelmnt hierarchy = zcost_lv2
Level 5 of 0costelmnt hierarchy = zcost_lv5
How can I do it with a transformation? Is there any wiki or documentation which tells the way?
I tried to explain in the following screen shot.