Hi Frzz,
I have complex requirement with respect to Hierarchies in HANA.
This is related to PS in which we have filds Header , Actvity and Element. Header is the top node. Each Header can have multiple Activities. With in activies we have Elements.
I have to generate the fields Activites and Elements based on the table information.
But the source table contains as like below.
Header Counter Act Node 7001 1 0010 7001 2 0020 7001 3 0030 1 7001 4 0040 2 7001 5 0050 2 7002 1 0010 7002 2 0020 7002 3 0030 2 7002 4 0040 2Output:
Header Activity Element 7001 7001 0010 7001 0010 0030 7001 7001 0020 7001 0020 0040 7001 7001 0020 7001 0020 0050 7002 7002 0010 7002 7002 0020 7002 0020 0030 7002 7002 0020 7002 0020 0040In the above result the Activity and Element is comuted based on the Node and counter. If node value is 1 then the value should come under the corresponding counter hearder node.
Can some one guide me to achive above requirement.
best Regards,
Krishna.