Symptom
In the “Custom Analytical Queries and Services” app, the hierarchy enabled dimensions do not show "Hierarchy Node" selection type in the Filter tab, unlike "Customer Analytical Queries" app.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the "Custom Analytical Queries and Services" app.
- Create a new query.
- Enable hierarchy for a dimension.
- Go to the Filter tab, the "Hierarchy Node" selection type not available.
Cause
Resolution
To apply a hierarchy node filter to a dimension in the "Custom Analytical Queries and Services" app, a parameter must be used.
Follow these steps to enable the hierarchy node selection type:
- In the Model tab, enable hierarchy for the required dimension.
- In the Parameter tab, create a parameter for that dimension.
- Navigate to the Filter tab, for the hierarchy enabled dimension, select "Filter with Fixed Values" and add the created parameter.
- Return to the Parameters tab, select the parameter created in Step 2.
- The option "Filter with Hierarchy Node" will now be available for selection in the Parameters tab.
Keywords
custom analytical queries and services, hierarchy node, hierarchy, selection type, filter , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem
Product
SAP S/4HANA Cloud Public Edition all versions
SAP Knowledge Base Article - Public