Expose CDS Views to SAP BW Bex Query Designer
This is the 2nd 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 Views
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.
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)
To leverage BEx capabilities and valid for embedded BW setup
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.