SAP Data Warehouse Cloud (DWC) is designed to extend the existing Enterprise Data Warehouse into the Cloud under the lead of the LoB users. Due to its easy to use design, look and feel, Data Harmonization tasks can be achieved directly within your LoB Departments with very little IT involvment.
When we talk about SAP BW Data Model and exposing logic out of SAP BW we talk about BEx/BW Queries. These Queries will be used to expose a Data set to the Front- End such as SAP Analytics Cloud for Data visualization.
We can re- use these Queries in order to expose this logic to DWC aswell. In that case you can secure your TCO that you invested in the past into your SAP BW Data Model.
In order to follow this Blog you need the following prerequisites fulfilled:
In order to consume your Queries within DWC, we have to mark your Query as an InfoProvider. Without doing this, the Query wont show up within DWC. So the general Overview looks like the following:
Identify your Query
Mark the Query as InfoProvider within SAP BW
Use it in your Graphical View
Identify your Query
In our case i created a simple Query for demoing. My Query is called CP02Q01_SALOVE and the definition looks like the following:
Not a beauty, but does the trick.
Mark the Query as InfoProvider
This part is mission critical. If we do not mark the Query as InfoProvider, the view out of DWC looks as follows:
Mark your Query as InfoProvider
Log- On to your SAP BW
Launch Transaction RSRT
Select your Query
Hit the Properties button
Select Query is used as InfoProviderPlease remark: If you get a notification telling you that your Query cannot be used as an InfoProvider, please check the limitations that apply when using a Query as an InfoProvider.
As of now, we can see our Query within DWC:
Use it in your Grapical View
At the end we are now finally able to use the Query within a Graphical View. In the first hand we import it:
Whereas afterwards it is ready to use within our Graphical View: