How to Expose the S4HANA ABAP CDS View to MS-Power BI

Using the following points to expose the S4HANA CDS view to MS Power BI


1. Creation of CDS View .
2. Creation of Odata service for the CDS view .
3. Consuming the Odata Service in Power BI .

Following Step by Step Process for the above points.


Point 1. Creation of CDS View.

Step-1.1 : For Creating the CDS view right click on package→New→Other ABAP Repository

Object.



Step-1.2 : Select the Data Definition in Core Data services.


Step-1.3 : Fill the details Project , Package ,Name & Description and Click on Next.



Step-1.4 : Click on Next.



Step-1.5 : Select the type of template is required and click on Finish.



Step-1.6 : See the Below mention Details & Script Screenshot which is expose the MARA Table With limited Columns . After Giving the Script Save the file.
  • ZCDS_SQL is the ABAP View name when activated view is created in ABAP
  • MARA is the table name (We can use the table or view Name)
  • ZCDS_DDL is the Entity name (File name is also same)
  • @Odata.publish:ture is used to expose the data trough odata default Odata name is ZCDS_DDL_CDS('Entity'+_CDS)


Step-1.7 : For activation the DDL file . Right click on DDL file and select Active option .



Step-1.8 : After click on active we can see the Activation pop-up.




Step-1.9 : File is successfully activated.



Step-1.10 : For Checking the ABAP view . Go to the GUI and Open the T-Code SE11 . Select the view and give the view name and click on Display.



Step-1.11 : For Checking the data click on Contents .



Step-1.12 : Select Execute.



Step-1.13 : Below Screenshot we can see the data which are given in the CDS view.



Point 2. Creation of Odata service for the CDS view.

Step-2.1: Open the T-Code /n/IWFND/MAINT_SERVICE & Click on Add Service.



Step-2.2 : Provide the System Alias & Technical Service Name and Click on Get Services . Click on Add Selected Services .


Step-2.3 : Then Service is added into the services list.




Step-2.4 : For Checking the Odata Select the service and click on Call Browser.


Step-2.5 : Below Response will come .




Point 3. Consuming the Odata Service in Power BI .


Step-3.1 : Select the OData Feed .



Step-3.2 : Fill the Odata URL and Click on OK.





Step-3.3 : Fill the Basic Authentication for Odata and Click on Save .




Step-3.4 : Select the Entity Name in the OData Service .


Step-3.5 : After Selecting the Entity click on Load.



Step-3.6 : After Click on load a pop-up will come.




Step-3.7 : After Loading Completed we can see the table in the Fields.



Step-3.8 : After Selecting the Columns in the fields we can see the data in Dashboard.

Comments

Popular posts from this blog

How to Expose the S4HANA ABAP CDS View to SAP BO

How to Expose the S4HANA ABAP CDS View to Fiori App