SAP Knowledge Base Article - Public

2472423 - Custom Analytical Query - Filter Error based on CDS view

Symptom

When creating a Custom Analytical Query based on CDS view, the preview work if no filter provided, however; when a filter in any of the Supplier field, no data can be previewed.

Environment

SAP S/4HANA Cloud Public Edition 1702

Reproducing the Issue

  1. Open the Fiori app 'Customer Analytical Queries'
  2. Open the ' YY1_AP_AGING_QUERY  '
  3. Go-to the filters tab
  4. Make sure that there are NO FILTERS set on ' Supplier ' and ' Name of Supplier ' rows
  5. Click on Preview data.  You should get a preview of data ' Before Filter '
  6. Go back to the filter tab
  7. Pick either ' Name of Supplier ' or ' Supplier ' row and create a filter.  Set the filter as: Fixed Values --> Exclue --> ' # '
  8. Save and then activate your query
  9. Preview the query.  Make sure that data is previewed and that you no longer see records for the value

Cause

This is a product issue.

Resolution

To work around this issue, follow the following steps as indicated in the screenshot below:

  1. The filter can be set by selecting the Supplier as shown below:
    YY1_query1.jpg

  2. Or this

    YY1_query2.jpg

Keywords

YY1 Query CDS filter, Custom Analytical Query filter error , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud 1702