CDS View Query Not showing in TCode RSRT

[surajyadavtokas]

Hi,

I created 2 CDS views and in both CDS view I changed only the name but one of the CDS views is not showing RSRT.

CDS view activated normally and display data in HANA studio on F8. But not visible in RSRT

CDS View :-

RSRT

Regards

Suraj Kumar

[Chaitanya_8779]

Please check the CDS API state whether it is Released or not.

How to check API state:

CDS View=>Properties=> API State

How to Make API State in Released :

Right click on CDS View => API State=>Add Use System-Internally (Contract C1)
it will open a pop-up as shown:

Just select all checkboxes and click on next.

[membership]

Were you able to resolve this issue? If so could you pls share the solution? Thanks..

[gasparerdelyi]

Check the data source (check against the documentation for @Analytics.query: true )
1.Is it an ABAP CDS View set as #CUBE or #DIMENSION by @Analytics.DataCategory annotation?
The most common root cause is the source is not such an ABAP CDS View.

2. Is a DCL assigned to this source? If not, that can also be the root cause

3. If both are OK, check first the ODP provider generated for the SQL view for the data source view in transaction RSRT... (in ABAP CDS context), and if you can reach the next screen, press "Check Metadata" and look for error messages there

4. If everything was OK so far, look around in RSRT: have a look at Messages, Technical Infrormation, Generation Log etc.

[former_member688242]

please check authorization of table as table name is different