Skip to Content

Hierarchies from BW to Analytics Cloud

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 15, 2018 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

    Add comment
    10|10000 characters needed characters exceeded

    • 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 ?