CDS Cube view cannot be consumed in SAC

[Private_Member_743020]

Hello Community,

An ABAP CDS cube view is not visible when I tried to open it in SAC(SAP analytical cloud).

I presume that there is annotation missing in the view.

Does anyone know what the possible reason is?

BR

Kai

[Siva_Raju]

For any CDS cube view , we need to follow annotation and expose it outside web.

For that we need to make sure below should complete before use it in SAC

• Contain the "@Analytics.query: true" Annotation
• API-state=released

[mfoeken · Accepted solution]

Hi kaixiansu,

Please check SAP KBA: 2595552 - Cannot access Core Data Services (CDS) View from SAP S/4HANA in SAP Analytics Cloud (SAC).

SAP Analytics Cloud only consumes Core Data Services (CDS) Views from S/4HANA with certain attributes:

• Contain the "@Analytics.query: true" Annotation
• API-state=released

Kind regards,

Martijn van Foeken | Interdobs

[Private_Member_743020 · Accepted solution]

Hi Martijn, thank you very much for your answer!

There is a very strange error report in my code, if I add in the @Analytics.query: true annotation:

It says: unvalid data source:no joins or unions supporting[Analyse]

Do you know why it is like this?

Does that mean, only query view can be consumed by SAC, cube view not?

BR

Kai

[mfoeken · Accepted solution]

Hi kaixiansu,

Could well be the case, you should test both to see which is supported. Maybe this blog is also helpful: A complete journey from a CDS view in S/4HANA cloud to an SAP Analytics Cloud story.

Kind regards,

Martijn van Foeken | Interdobs