Skip to Content
0
Former Member
Apr 14, 2014 at 02:17 PM

Query on Hierarchy build

24 Views

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 2

Output:

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 0040

In 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.