Forum Discussion
Connection to SAP S4HANA Analytics CDS views
As Lydia mentioned, ODATA service and the Power BI connector for Odata can be used.
Other option is generate a Calculation view for the CDS view and use the Calc view through the POwer BI SAP HANA connector. :-)
Please could you give me some more information or link to article about how to generate calculation view from CDS view? I am trying to find something but not really successful. Thank you very much.
It is possible but you have a few items to consider.
1.) Most CDS views exists as table valued functions in the SAP ABAP schema. They are not standard Tables or Views to that regard. A calcualtion view supports this as a data source but you have to map the Function's input parameters (if they exist) to a calculation view's input parameters.
2.) Some of the table valued functions use a the session variable SESSION_CONTEXT( 'CDS_CLIENT') which is dificult for users to set under an ODBC session using PowerBI. Therefore, you likely need to make a custom copy of each table valued function and replace that with the SESSION_CONTEXT( 'CLIENT') which is a standard varable that can be assigned to each HANA database user.
3.) You have to create and maintain the metadata (Column Lables) in the Caclcualtion View. This can take some time to setup.
4.) You have to manage the security on the HANA database but there are numerious ways to automate that.
--- Frankly I think it would be all around better to build a real-time data mart in a sidecar instances of HANA then to try and maintain raw CDS code within the database, wrapped with calcualtion views.