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 modify your query to use either filteringFacet or filteringAttribute, but not both. Here are the steps you can take:
  
  
  Review Your Query: Check the query parameters you are using. Identify where both filteringFacet and filteringAttribute are being set.
  
  
  Choose One Filtering Method: Decide whether you want to filter by facet or by attribute based on your requirements. Remove the one that is not needed.
  
  
  Test the Query: After making the changes, test the query again to ensure that it executes without errors.
  
  
  Related Information:
  
  Documentation: Refer to the official SAP documentation for Enterprise Search and CDS views to understand the correct usage of filtering parameters.
  SAP Community: Engage with the SAP Community forums for additional insights and solutions from other users who may have encountered similar issues.
  Debugging: If you are still facing issues, consider enabling debugging or logging to get more detailed information about the query execution and the parameters being passed.
  
  By following these steps, you should be able to resolve the ESH_ENG_CDSVAL_ES046 error and successfully execute your query.