Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to use BODS hierarchy flattening transformation with 3 or more columns.

Hi  Experts,

I have gone through some hierarchy flattening examples where source data is like below

Source Data

--------------

Emp_Id

Mgr_Id

Say that we have 4 levels of horizontal hierarchy flattening, then we get in our results:

Target Data

-------------

Current_Leaf

Leaf_Level

Level0

Level1

Level2

Level3

Level4

But what happens when the source data contains

Source Data

--------------

Emp_Id

Emp_Type

Mgr_Id

and we need  target data like

Target Data

-------------

Current_Leaf

Emp_Type

Leaf_Level

Level0

Level1

Level2

Level3

Level4

How do we achieve this using Hierarchy Flattening transformation where we want to carry some of the child attributes to the flattened structure ?

Thanks in Advance.

-Sam

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question