Expose CDS Views to SAP BW Bex Query Designer

[Prabhith]

Hello All,

This is the 2^nd Part of my attempt, to bring to you some of the additions that has happened to the BW world, post the launch for S/4 HANA.

You can find Part 1 Here --> Solution for 0ANALYSIS Issue while trying to access ‘Open in Design Studio’ option of S/4HANA CDS Vi...

By now, you might be aware that in S/4 HANA we have a very important concept called CDS.

I don’t want to explain the complete history/details of CDS views here, as it’s been explained in detail elsewhere.

In this blog, I would like to introduce an approach by which you can consume CDS Views in BW Bex Query Designer.

The following figure shows the Fiori Launchpad of a S/4 HANA System.

Once you open the Query Browser, you will find the available CDS Views.

Here we are talking exclusively about the View C_DAYSSALESOUTSTANDING.

SAP Says:

All S/4HANA CDS views are automatically exposed as a ODP transient InfoProvider and can be used in the BEx Query Designer to define custom queries.

(Inherited from SAP Standard Document)

Use Cases:

To leverage BEx capabilities and valid for embedded BW setup

Capabilities:

All S/4HANA Analytics Open CDS views are automatically exposed as InfoProvider in BEx Query Designer Supports BEx variables

Supports restricted key figures

Supports exceptions and conditions

Supports currency conversion

Supports BW Report-to-Report interface

Supports S/4HANA Analytics privileges

Not supported (Query not based on BW InfoObjects):

BW Hierarchies, node variables

BW analysis authorizations

PS:Please note that the above points were derived for SAP document on SAP S/4HANA Analytics & SAP BW Data Integration.

Now, we will log into a BW Query Designer of the embedded S/4 HANA System and identify the required system.

Provide the Credentials:

Open a New one:

For ease of identification: Search with 2C* as transient Provider starts with that naming convention.

Open the required one, In our case it is Days Sales Outstanding Smart Business App.

Now play around with the Query and design a  custom one,  according to your requirement.

Hope this gives you an idea of how we can expose a CDS View in our Query Designer.

BR

Prabhith