SAP Data Warehouse Cloud: Consume SAP BW based Queries

[former_member136842]

Introduction

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.

Versioning

Document Version	0.1
Document Date	19.11.2020
DWC Version	2020.23.56

Prerequisites

In order to follow this Blog you need the following prerequisites fulfilled:

1. You have meet the DWC System requirements


2. Your DWC Tenant is connected to your SAP BW


3. You are using the SAP ABAP connection Tile


4. You have a BEx/BW Query


5. None of the limitations apply
   
   
   
   • SAP BW on HANA Limitations
   
   
   • SAP BW/4HANA Limitations
   
   
   
   

Consume SAP BW based Queries

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:

1. Identify your Query


2. Mark the Query as InfoProvider within SAP BW


3. 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

1. Log- On to your SAP BW


2. Launch Transaction RSRT


3. Select your Query


4. Hit the Properties button


5. 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:

Further Information

If you seek for further DWC Information material, hit the DWC Product Page.

You need more help during your Implementation? Check the Product documentation for helpful implementation Guides.

Want to know whats coming up in the DWC Universe? Check the DWC Roadmap.

Regards
-Seb.