Dynamically change of Hierarchies in SAP HANA

[former_member1048438]

Hi All,

Anyone can suggest me the below requirement is possible with SAP HANA.

i.e. If initially, Hierarchy H1 built on L1--> L2 --> L3 , where L1, L2, L3 are level nodes and in turn each of them would have different child nodes below them, change will happen in such a way that H1 could have L3--> L4 --> L7 -->L9 , assume that these are levels.

Thanks,

GnR

[former_member185132]

This can be achieved by Parent-Child hierarchy in attribute views. Just google for it, there are several examples.

Basically load the parent/child relations into a table and use that as the basis for the hierarchy. When the data in the table changes, the hierarchy will automatically get realigned.