How to access S4HANA CDS Views from SAP Analytics cloud(SAC)

[tnithya13]

Trying to create SAC Dashboard based on se11 Ztable. Have created CDS view on top of Ztable in Eclipse and used annotation @Analytics.query: true". But, when tried to access from SAC - S4HANA live connection, unable to find any datasources except for 2C Datasources. is there any settings needs to be enabled from SAP? Is it possible to implement by any other way?

Thanks,

Nithya

[sasidharg]

Hello Nitya,

Hopefully you got your answer or else we have to include @oData.publish:true annotation in your cds view,

Best Regards,

Sasidhar

[tnithya13]

Hello Sasidhar Gunturu,

Thanks for your reply.

I already tried including @oData.publish:true annotation, still could not see the Datasource in SAC.

Nithya

[William_Yu]

We accepted the answer for you at the moment, please feel free to reopen if you not satisified with the answer.

[jannis · Accepted solution]

Hello Nithya,

Could you please search for 2C"technical name of your cds"? The Annotation @Analytics.query: true should create a query with the prefix 2C followed by the technical name of your cds. You can also search for it via TCODE: RSRT.

Best Regards,

Ioannis

[tnithya13 · Accepted solution]

Thanks for the reply Ioannis.

Actually, annotation @Analytics.query: true did not work and when tried to activate CDS, it shows below error.

eclipse-error.png

And if its removed, then CDS Gets activated. And when ran(ctrl+f11) the cds view, able to see table data in Eclipse.

is it possible to use the 'annotation @Analytics.query: true' when using Ztable as source or is it only possible when using cube?

Thanks,

Nithya

[jannis · Accepted solution]

Could you please try to create a 'base' CDS view using Ztable and the try to use that CDS view in another 'Consumption' CDS view with @Analytics.query: true' .

Best Regards,

Ioannis

[JohnL · Accepted solution]

check these out as well:

https://blogs.sap.com/2019/11/29/consume-cds-views-in-s-4hana-step-by-step/

https://blogs.sap.com/2021/01/12/sap-analytics-cloud-supported-s-4hana-objects-and-how-to-find-them/

https://userapps.support.sap.com/sap/support/knowledge/en/2595552

[tnithya13]

Hey John,

Version of S/4HANA is 2020 and embedded version is 755. please let me know if any other details needed.

Regards,

Nithya

[tnithya13]

Hey Ioannis,

As Suggested, I did try creating basic cds first and top of that Consumption view. it is throwing same error.

"Error reading Infoprovider for CDS View"

I also tried creating basic cds, on top of that composite type and on top of composite I did consumption. everything works fine when I remove annotation @Analytics.query: true. if added its throwing the error.

I wonder if this is possible using ZTABLE at all?

hey John,

I tried those links but it did not help achieving CDS View with @analytics.query:true.

Thanks,

Nithya

[JohnL]

Hi tnithya13 , what version of S/4HANA are you on? What is the embedded BW version ? 751/752/753/754

Thx,

John