Skip to Content

Hierarchies from BW to Analytics Cloud

5 days ago


avatar image

Dear Community,

did anyone manage to find a good way to create hierachies in BW which then can be imported to SAP Analytics Cloud.

At our customer we have a 5 level based Column hierachy based on Material Attributes. It is currently impossible to import those attributes and merge them in AC (see description here)

Another option would be to create different InfoObjects, and combine those in a DSO, but again, it is not possible to import a DSO, and the problem with BW queries is that they need a common key, which would not be the case for all different attributes.

did anyone find a good work around for this?

Question 2: How to maintain the Master Data well in SAP AC

Also, how to then update that hierachy regularly. The easies way to import Master Data is via Public dimensions, which currently cannot be scheduled. Meaning that someone would need to manually update the master data before the nightly data load.

Importing it with the transaction data is difficult, as you need to map the master data with the transactional data and a date dimension.

10 |10000 characters needed characters left characters exceeded

Is a live connection possible? Then you don't have to rely on updates.


Nope, the BW performance is not good enough for a live connection. And it is not part of the scope to remoddel BW accordingly :(


Any Ideas from anyone?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ingo Hilgefort
2 days ago

Hi Daniel,

you mentioned "import" so I assume you are using the data import option ?

You should leverage the live data connection to BEx queries, which also gives you direct access to all the hierarchies.

That also resolves your question 2, because your masterdata is in BW


Ingo Hilgefort, SAP

10 |10000 characters needed characters left characters exceeded