Skip to Content
avatar image
Former Member

How to bring Cost Center Hierarchy into HANA

Hello,

I have to design a new Data Model in SAP HANA (Native HANA using Studio), as per user requirement that user will be choosing a Hierarchy in ECC and the same Hierarchy he wants to choose in BI report also., please give me a some inputs on how to design this.

thanks,

P

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 15, 2017 at 10:03 AM

    Hi Prashant,

    Is your ECC and BW is on same HANA DB OR you have two different systems (ECC & BW seperate)?

    There are two ways:

    1. Using the BW Objects on HANA, i.e. creation of InfoObject same as ECC (where user is creating hierarchy). Try to load hierarchy data from ECC to BW for this InfoObject.

    2. If you are using Native Hana, create the hierarchies manually at the Calculation View Semantics same as ECC hierarchy. From this point, you can expose to BW reporting layer and use the hierarchies.

    Hope it helps!

    Thanks,

    Umashankar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2017 at 02:58 PM

    Thanks Umashankar.

    We are on HANA 2.0 and no SLT, we are building HANA views on SAP SoH.

    I was going through the below link, to develop my scenario but not yet successful and not sure whether "input parameter" will display just like BEx Hierarchy Variable Parent to Child Levels/dropdowns (*we are on BO 4.2).

    I need help in creating Graphical Hierarchy, kindly someone shares their experience or expertise in developing the Graphical Hierarchies.

    https://blogs.sap.com/2017/08/01/implementing-graphical-hierarchy-view-for-profit-center-in-sap-hana/

    thanks,

    P

    Add comment
    10|10000 characters needed characters exceeded