Skip to Content

Hierarchies from BW to Analytics Cloud

Mar 12 at 11:20 AM


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?


Hi Daniel,

Updates/imports to Public dimensions can now be scheduled.

Public dimensions now have a "Datasources" tab.

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

1 Answer

Ingo Hilgefort
Mar 15 at 02:27 PM

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Ingo, this would be a nice solution, but for this particular customer we want to choose for the import option, because of perfomance questions. Otherwise we would need to do loads of things in the back end of BW, which is not part of the scope.

Any other suggestions?


Hello Daniel,

so you have 5 hierarchies in BW but you also mentioned that you can't combine these hierarchies in BW.

Correct ?

So - if you can't join the data in BW, how did you want to join it in SAC ?