How To Fix ESH_ENG_CDSVAL_ES046 - 'filteringFacet' and 'filteringAttribute' are mutually exclusive (&1)

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_ENG_CDSVAL_ES - ES-CDS/ABAP: Validation of domain @EnterpriseSearch

• Message number: 046

• Message text: 'filteringFacet' and 'filteringAttribute' are mutually exclusive (&1)

What causes this issue?

The element is annotated as @EnterpriseSearch.filteringAttribute and as
@EnterpriseSearch.filteringFacet. These annotations are mutually
exclusive, and combined usage does not make sense.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Remove one of the annotations: For highly selective elements (like IDs),
facets do not make any sense - highly selective elements ought to be
treated as filtering attribute. Medium selective elements tend to act as
facets.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ESH_ENG_CDSVAL_ES046 - 'filteringFacet' and 'filteringAttribute' are mutually exclusive (&1) ?

  The SAP error message ESH_ENG_CDSVAL_ES046 indicates a conflict between the filteringFacet and filteringAttribute parameters in a query. This error typically arises in the context of SAP's Enterprise Search or SAP HANA when using Core Data Services (CDS) views, particularly when trying to filter search results.
  
  Cause:
  The error occurs because both filteringFacet and filteringAttribute are being used simultaneously in a way that is not allowed. In the context of SAP's search framework, these two parameters are mutually exclusive, meaning you cannot use them together in the same query. 
  
  filteringFacet: This is used to filter results based on a specific facet (a category or attribute that can be used to narrow down search results).
  filteringAttribute: This is used to filter results based on a specific attribute of the data.
  
  When both are specified in a query, the system cannot determine which filtering method to apply, leading to this error.
  
  Solution:
  To resolve this error, you need to