In the previous blogs (Part 1, Part 2, Part 3) we configured the integration of SAP Data Warehouse Cloud in combination with our SAP BW 7.5 System. So in this session we will use a BW Query and join the masterdata via the tables for the InfoObject.
After we configured all elements, and we configured our BW Query to act as InfoProvider, we can then bring in our BW Query into a new View in SAP Data Warehouse Cloud. Please note, that the BW Queries are listed as part of the category Extractors – BW as part of the ABAP Adaptor.
In my example, I am using a relatively simple BW Query, with three dimensions and three measures. After you imported the view from the BW Query, you can notice a few things right away:
- All characteristics / dimensions are only brought into SAP Data Warehouse Cloud with the key column and the description column is not being brought in.
- The technical name for the keyfigure is not represented by the InfoObject name, but instead SAP Data Warehouse Cloud is using the technical name that you can define in the BW Query. In case you did not maintain it, then SAP Data Warehouse Cloud will assign field names.
- In my case all three key figures have a currency / unit assigned, so you will see a column for that as well.
Above you can see the Data Preview of the BW Query in SAP Data Warehouse Cloud. So now we need to bring in the descriptions for our dimensions, so that we can then show the ID as well as the description of the dimension, for example Country.
In our scenario that means that we need to point towards the Text table for the InfoObject in BW (/BI*/T<characteristic>), so in my case I will create a View in SAP Data Warehouse Cloud pointing to the table /BI0/TD_NW_CNTRY.
You can see the Data Preview of the Text table, and all I need to do for my example is to add a filter on the language.
Last but not least, I then create a new View where I join the view pointing to the BW Query with the view pointing to the text for the dimension.
I then setup the join between the two key columns from the BW Query and the Text table,
and I now have a view that has the BW Query and the Dimension descriptions joined and I can see key and description in the Data Preview in SAP Data Warehouse Cloud.
So in case you want to follow the steps along, perhaps sign up for a trial and get a system ready to leverage information from your SAP BW system in combination with SAP Data Warehouse Cloud.