cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Not all SAP S4 BW ABAP CDS views are visible from Power BI?

HI All

 

I am trying to access SAP HANA S4 ABAP CDS views through SAP BW application from PowerBI. 

However, it is not all the CDS views that are visibles from the PowerBI. 

I have created a CDS view Type #Cube @analytics: { dataCategory: #CUBE}, which is visible from PowerBI. 

However, we also have a Type #Query (@Analytics.query: true)  build on top of that Cube, but this Query can't be seem from the PowerBI. 

 

Do you know how we can make this query (Type #Query (@Analytics.query: true) ) available to PowerBI so that we can build reports from PowerBI based on this CDS query?

 

 

Thanks

Tracy

3 REPLIES 3
Highlighted
Frequent Visitor

Re: Not all SAP S4 BW ABAP CDS views are visible from Power BI?

Can anyone help on this? We kind of get stuck and would like to have some solution ASAP.

 

Thanks

Highlighted
Community Support
Community Support

Re: Not all SAP S4 BW ABAP CDS views are visible from Power BI?

Hi @TracyTTT 

Do you use the built-in SAP HANA connector or oData?

Have you ever read these references?

Create CDS views in SAP S/4HANA Cloud and consume them as APIs

From a CDS View to an OData Service for Analytics

 

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Frequent Visitor

Re: Not all SAP S4 BW ABAP CDS views are visible from Power BI?

Thanks Maggie for the response.

However, we would prefer not to use OData service, for the reason that the hierarchy built from SAP CDS is not usable if using OData service, and also for the input parameters for refreshing report doesn’t seem to work.

 

Or if there is a way for the SAP CDS hierarchies and the query parameters to be working using the OData service?

 

 

Thanks in advance

 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021