How To Fix RSRTS_CDS112 - No default for filter on &1 provided: Filter cannot be hidden

SAP Error Message - Details

• Message type: E = Error

• Message class: RSRTS_CDS - Messages Transient CDS Queries

• Message number: 112

• Message text: No default for filter on &1 provided: Filter cannot be hidden

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRTS_CDS112 - No default for filter on &1 provided: Filter cannot be hidden ?

  The SAP error message RSRTS_CDS112 indicates that there is an issue with a filter in a query that is based on a Core Data Services (CDS) view. Specifically, the error states that there is no default value provided for a filter, and as a result, the filter cannot be hidden. This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when working with queries in the SAP Business Explorer (BEx) or Analysis for Office.
  Cause:
  
  Missing Default Value: The filter in question requires a default value to be set, but it has not been configured. This can happen if the filter is mandatory and no default value is provided.
  Filter Configuration: The filter might be set to "hidden" in the query definition, but since it is mandatory and lacks a default value, the system cannot hide it.
  Query Design: The query might be designed in such a way that it expects certain filters to be filled in, but the design does not accommodate the absence of a default value.
  
  Solution:
  
  
  Set Default Value:
  
  Go to the query designer in SAP BW or the relevant tool you are using.
  Locate the filter that is causing the issue.
  Set a default value for the filter. This can often be done in the properties of the filter.
  
  
  
  Change Filter Properties:
  
  If the filter is not mandatory, consider changing its properties to make it optional.
  If it must remain mandatory, ensure that a default value is always provided.
  
  
  
  Check Query Settings:
  
  Review the query settings to ensure that filters are configured correctly.
  Make sure that any filters that are set to be hidden do not have mandatory settings without default values.
  
  
  
  Test the Query:
  
  After making changes, test the query to ensure that the error no longer appears and that the query behaves as expected.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional guidance on handling filters in queries.
  Documentation: Review SAP documentation on query design and filter management in BW or HANA to understand best practices.
  Community Forums: Consider searching or posting in SAP community forums for additional insights from other users who may have encountered similar issues.
  
  By addressing the filter configuration and ensuring that default values are set appropriately, you should be able to resolve the RSRTS_CDS112 error.