Symptom
You have created a custom analytical query using standard CDS view "I_APJRNLENTRITMAGINGGRID", however, when editing the query, you observe that parameter "P_KeyDate" does not show in the filters of the query.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the app Custom Analytical Queries and Services.
- Select the affected custom analytical query.
- Go to the Filters tab.
- Observe that the parameter "P_KeyDate" is not listed.
Cause
The parameter "P_KeyDate" is defined using the system field SYDATE without derivation or default value annotations, so the system assigns the current date and treats the parameter as hidden at runtime.
Resolution
You can create a custom CDS view with data source "I_APJRNLENTRITMAGINGGRID", and recreate the parameter "P_KeyDate". After published the custom CDS view, create a new custom analytical query using the CDS view as a data source. Steps as below:
- Open the app Custom CDS Views.
- Create a new custom CDS view with an analytical scenario (for example, Analytical Cube) based on data source "I_APJRNLENTRITMAGINGGRID".
- Navigate to the Parameters tab of the custom CDS view.
- Delete the parameter P_KeyDate.
- Add a new parameter with the same name and label as the deleted parameter. (Name and Label: P_KeyDate )
- Adjust the CDS view as required and publish it.
- Create a new custom analytical query using this custom CDS view as a data source.
- Open the query and verify that P_KeyDate is now available under Filters tab.
See Also
Keywords
key date, P_KeyDate, parameter not visible, filters tab, custom analytical query, query filters, cds view, custom cds views, analytical cube, data source parameter, filter parameter, runtime parameter , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem
SAP Knowledge Base Article - Public