Skip to Content
Author's profile photo Prabhith Prabhakaran

Expose CDS Views to SAP BW Bex Query Designer

Hello All,

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.

/wp-content/uploads/2016/02/1_884612.png

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

Here we are talking exclusively about the View C_DAYSSALESOUTSTANDING.

/wp-content/uploads/2016/02/2_884613.png

/wp-content/uploads/2016/02/3_884615.png

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.

/wp-content/uploads/2016/02/4_884621.png

/wp-content/uploads/2016/02/5_884616.png

Provide the Credentials:

/wp-content/uploads/2016/02/6_884622.png

Open a New one:

/wp-content/uploads/2016/02/7_884623.png

/wp-content/uploads/2016/02/8_884624.png

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

/wp-content/uploads/2016/02/9_884626.png

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.

/wp-content/uploads/2016/02/10_884627.png

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



BR

Prabhith

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sri Govind KR
      Sri Govind KR

      Hello Prabhith,

      It was good reading about the one of the possibilities of exposing ABAP CDS views. One question that i have is regarding the statement

      Not supported (Query not based on BW InfoObjects):

      BW Hierarchies, node variables

      BW analysis authorizations

      that you have mentioned. Do you know about any timelines as to when this will supported in Bex queries that are created from the ODP Transient provider?

      Thanks and Best Regards,

      Govind

      Author's profile photo Philipp Nell
      Philipp Nell

      Thanks for the effort putting this together !

      Author's profile photo Muthuram Shanmugavel
      Muthuram Shanmugavel

      Hi Prabhith,

      Thanks for document. Great effort.

      I have one question.

      Description for both CDS View and Transient Provider is same.

      But technical name of CDS View Name is C_DAYSSALESOUTSTANDING

      and Transient Provider Name is 2CIFIDAYSSLSOUTSTG.


      How the Transient Provider Technical Name is derived from CDS Tech Name.

      Else we have to find it using description only?


      Regards,

      Muthuram

      Author's profile photo Do Hai Dang Le
      Do Hai Dang Le

      Hi Muthuram, are you still interested in the question?

      The name Transient Provider is 2CIFIDAYSSLSOUTSTG because it has nothing to do with the CDS View C_DAYSSALESOUTSTANDING. It belongs to the CDS View I_DaysSalesOutstanding, whose sqlViewName is IFIDAYSSLSOUTSTG (see the resemblance?).


      I_DaysSalesOutstanding is a CDS View of Type #Composite and its dataCategory is #Cube. This combination of annotations makes it a TransientProvider to be used with BEx Query Designer. The C_DAYSSALESOUTSTANDING View with Type #Consumption, on the other hand, is built on top of I_DaysSalesOutstanding and allows fiori apps to consume data from the cube-like I_DaysSalesOutstanding

      Author's profile photo Muthuram Shanmugavel
      Muthuram Shanmugavel

      Thank you 🙂

      Author's profile photo Jayasimha Reddy Vangala
      Jayasimha Reddy Vangala

      nice document. Thanks for your effort.

      Author's profile photo Former Member
      Former Member

      hi Prabhith,

      Nice sharing. Thank you.

      But I have a doubt here...

      All the S4HANA CDS views are automatically exposed as ODP transient provider and can be used in BEx query as you mentioned. However, the analytic query view C_APOVRD cannot be found in BEx, while its interface view I_APOVRD can be found with technical name 2CIAPOVRD. so how do analytic query views expose in BEx query?

      Thanks,

      Anni

      Author's profile photo Former Member
      Former Member

      Hi Prabhith,

           Useful sharing. Thank you.

           Can you please guide me, from which version of  BEx query designer, supports parameterized CDS view?

      Thanks,

      Tejaswini.

      Author's profile photo Former Member
      Former Member

       

      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

       

      My comments:

      It's a good idea to utilize features of existing Bex tool.  But entire query may or may not be pushed down to database. Is there a clear guideline as to which features can be pushed down to database? Or easier way is to disable all Bex options that are not supported for transient providers or cannot be pushed down at the moment.

      Author's profile photo TARUN PATODI
      TARUN PATODI

      If cds view is delta enabled and we are consuming cds in bex query...then will we get all records or based on delta?

      Author's profile photo Martin Sautter
      Martin Sautter

      Hi,

      ...any idea how to publish  the BEX based (transien)  CDS Query back into the Fiori bubble again ?

      What means to bring it back to the Query Browser ?

       

      ​What means having a more comprehensive and more complete drop & drag tool ( Eclipse for BW for transient CDS)  ​than the Fiori App Custom Analytical App and using the result with in the Fiori "App" Bubble.
      ​
      ​ThanXs

      Martin