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