Skip to Content
0

How to bring Cost Center Hierarchy into HANA

Sep 14, 2017 at 05:56 AM

256

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 19, 2017 at 02:58 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded