Loading ECC fund centre hierarchies in to HANA

[former_member327592]

Hi,

I can not see any where how to load ECC hierarchies into HANA .  If you know please advice how to .

Thanks

Mano

[former_member584323]

Did you ever solution this and did your Hana Output match that of ECC Tcode FMSE? would you be willing to share that solution?

[former_member327592]

Hi Tammi,

We have used BW tables for hierarchies ,pulled into HANA and used multiple joins .

[Former Member · Accepted solution]

Hi Manoj,

From ECC, we bring ECC tables as it is in SAP HANA using SLT.

Then while creating different views in SAP HANA, we can define hierarchies in SAP HANA Studio.

We create hierarchies between attributes to improve analysis by displaying attributes according to their defined relationships.

There are two types of hierarchies:

Level Hierarchy: The root and child nodes are accessed only in the defined order. It consists of one or more levels of aggregation.
Example: We can drill down from Country to State and to City etc.

Parent/Child Hierarchy: This hierarchy contains a parent attribute and constructed from a single parent attribute.
Example: Employee master (employee and manager).

Please let me know if you have any other specific question.

Please assign points if this helped you.

Thanks and Regards,

Shyam Alok

[Former Member · Accepted solution]

Also, you may please refer the following links for more infomrations on SAP HANA Hierarchies on different views :

http://www.saphana.com/docs/DOC-2375
http://www.saphana.com/docs/DOC-2376