transform hiearchy levels to navigational attributes

[former_member220449]

Hello Gurus,

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.

[former_member220449 · Accepted solution]

In this documentation, it tells a method by creating a transformation from attribute to attribute with an end routine.

I guess this is the answer of my question.

I'll try it and let know.

[former_member220449 · Accepted solution]

Yes, it works

Thanks a lot to the author.