cancel
Showing results for 
Search instead for 
Did you mean: 

S/4HANA CDS not showing under Custom Analytical Query

Ashali
Participant
0 Kudos

2023-04-06-11-29-19-custom-cds-view-published.jpg2023-04-06-11-38-49-cds-view-not-found-in-analytic.jpgHi

I created a custom CDS view (see attached Custom CDS View Published), but its not appearing in Custom Query Analytical Queries (see attached CDS View Not Found in Analytical Queries).

Any help much appreciated

Thanks

Ashraf
S/4HANA Public Cloud

JulianoRomanato
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello ashraft.

How are you? I have excluded the Tag "SAP S/4HANA Cloud" and included the Tag "SAP S/4HANA Cloud Extensibility" for this question, as Custom Analytical Queries are related to Extensibility.

Regards.

Juliano Romanato.

TamasFodor
Advisor
Advisor
0 Kudos

Hi,

We helped you to accept the answer, since there were no updates after 7 days. You can unaccept it anytime if you have further questions.

Kind regards,

Tamas

Accepted Solutions (1)

Accepted Solutions (1)

PrasanthM
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Ashraf,

The custom CDS view should be of type, Analytical Cube, to be displayed in the app, Custom Analytical Query. You can find more details here https://blogs.sap.com/2022/04/26/how-to-create-analytical-query-from-custom-cds-view/

Best Regards,

Prasanth

Ashali
Participant
0 Kudos

Thanks Prasanth.

Ashraf

Answers (1)

Answers (1)

Tayane
Advisor
Advisor

Dear Ashraf,

In the screenshot attached I can see that your Custom CDS View is of type Standard CDS View.

In order to use a Custom CDS View in Custom Analytical Queries app, you need to create a Custom CDS View of type Analytical Cube or Analytical Dimension.

Please check the following blog post for modelling rules: SAP Blog Post | Creating Custom CDS Views for Analytical Scenarios - Modelling Rules.

Hope this helps you.

Best regards,

Tayane,

SAP Support.

Ashali
Participant
0 Kudos

Thanks Tayane, I will review

Ashraf

Ashali
Participant
0 Kudos

Hi Tayane,

I created CDS custom view with type Analytical Cube, but now when I try to add required Data Source, add search doesn't show I-MaterialDocument, which I want to use in my Analytical Query. I am attaching screen prints for required data source from View Browse and CDS view from Custom CDS view.

Thanks in advance

Ashraf2023-04-11-0-36-12-view-browse.jpg2023-04-11-0-35-03-custom-cds-view.jpg

Ashali
Participant
Tayane
Advisor
Advisor
0 Kudos

Dear Ashraf,

The CDS View is not showing in the search probably because the search is being filtered by "Recommended Data Source".

The data sources are automatically filtered by suitability so that initially only those data sources that are considered suitable for view building are displayed.

To resolve this, click on "Show Filters" and set the filter for "Recommended Data Source" to "No".

After that the CDS View for Material Document should be available.

Regards,

Tayane,