3704670 - Hierarchy parameters become mandatory when using Hierarchy Node filters in Custom Analytical Query - SAP S/4HANA

When creating a Custom Analytical Query and adding hierarchy nodes as filters (for example: Profit Center, Functional Area, or G/L Account), the system displays the corresponding hierarchy parameter as mandatory in the report, even though the hierarchy field was not configured as mandatory in the Custom Analytical Query app. See the following behavior:

• The report shows both:
  • a) The hierarchy parameter (composite key field)
  • b) The hierarchy node
• The hierarchy parameter cannot be left blank.
• Attempting to select a hierarchy node without entering the hierarchy parameter results in an error.
• In the generated CDS view, the hierarchy binding appears as #PARAMETER.

The expectation is that multiple hierarchy filters could be added without becoming mandatory.

• SAP S/4HANA 2023
• HEC system
• Custom Analytical Query (Fiori App)
• Key User Extensibility Tools

"Custom Analytical Query", "hierarchy mandatory", "hierarchy filter mandatory", "hierarchy node", "composite key", "Profit Center Hierarchy", "Functional Area Hierarchy", "GL Account Hierarchy", "P_FunctionalAreaHierarchy", "P_ProfitCenterHierarchy", "CDS parameter", "#PARAMETER", "#USER_INPUT", "Custom Query filter", "CAQ mandatory filter", "Key User Extensibility", "analytical query hierarchy", "custom query hierarchy binding", "hierarchy selection", "optional hierarchy", "CDS hierarchy parameter", "SAP S/4HANA on premise", "Custom Analytical Query app", "Fiori CAQ", "ABAP Platform extensibility", "BC-SRV-APS-EXT-AQD", "hierarchy composite key mandatory" , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem