Symptom
When previewing a custom query in the 'Custom Analytical Queries' app, the default values list for user input filters in the filter section is empty.
Environment
SAP S/4HANA Cloud Public Edition
Cause
Value help, display properties, texts, and hierarchies in the Custom Analytical Queries app are only available when a 'Master Data View' is maintained in the 'Custom CDS Views' app.
Resolution
The data source of the custom analytical query (Custom CDS View) containing the field must define a 'Master Data View' for that field in the Custom CDS Views app.
Steps to follow:
- Open 'Custom CDS Views' app.
- Select the CDS view used as the data source for custom analytical query.
- In the 'Element Properties' step, assign the 'Master Data View' to the specific field.
- Save and publish the CDS view.
See Also
Refer the following documents
Keywords
custom analytical query, filter, user input values, search suggestions, master data view, CDS views, value-help, display properties, texts, hierarchies, SAP S/4HANA Cloud , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem
SAP Knowledge Base Article - Public