How To Fix CM_SUB_INFOSYS021 - Manual reductions will be lost in the query

SAP Error Message - Details

• Message type: E = Error

• Message class: CM_SUB_INFOSYS - Substance information system

• Message number: 021

• Message text: Manual reductions will be lost in the query

What causes this issue?

During your search, you have performed a manual reduction of sets of
hits and now you want to store the search history as a query. However,
in queries, you cannot perform manual reductions.

System Response

The system deletes all steps with manual reductions. You can save all
remaining steps as queries.
<ZH>Caution:</>
Deleting the manual reductions distorts the search result. The amount
of results is however always increased and never decreased.

How to fix this error?

On the following screen, you can save the query without manual
reduction, or cancel the saving of queries.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CM_SUB_INFOSYS021 - Manual reductions will be lost in the query ?

  The SAP error message CM_SUB_INFOSYS021 indicates that manual reductions made in a query will be lost. This typically occurs in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence) when users are working with queries in the BEx (Business Explorer) Analyzer or similar reporting tools.
  Cause:
  The error message is triggered when:
  
  Manual Reductions: Users have applied manual reductions (filters) to a query, but the query is being executed in a way that does not retain these manual changes.
  Query Design: The query might be designed in such a way that it does not support retaining manual reductions, or the settings in the query properties do not allow for this.
  Data Source Changes: If the underlying data source or InfoProvider has been changed or updated, it may lead to the loss of manual reductions.
  
  Solution:
  To resolve this issue, consider the following steps:
  
  
  Save Query Changes: If you want to keep the manual reductions, ensure that you save the query after making the changes. This can often be done by saving the query variant.
  
  
  Check Query Properties: Review the properties of the query in the Query Designer. Ensure that the settings allow for manual reductions to be retained. Look for options related to "manual filters" or "user-specific settings."
  
  
  Use Query Variants: Instead of relying on manual reductions, consider creating query variants that include the necessary filters. This way, you can easily switch between different views of the data without losing your settings.
  
  
  Consult Documentation: Refer to SAP documentation or help resources for specific guidance on handling manual reductions in queries. This can provide insights into best practices and configuration settings.
  
  
  User Training: Ensure that users are trained on how to properly use queries and understand the implications of manual reductions. This can help prevent confusion and errors in the future.
  
  
  Contact Support: If the issue persists and you cannot find a resolution, consider reaching out to SAP support for assistance. They may provide insights specific to your system configuration.
  
  
  Related Information:
  
  SAP BW/BEx Documentation: Review the official SAP documentation for Business Warehouse and BEx Analyzer for detailed information on query design and management.
  SAP Community: Engage with the SAP Community forums where other users may have encountered similar issues and can share their solutions.
  SAP Notes: Check for any relevant SAP Notes that may address this specific error message or provide patches and updates that could resolve the issue.
  
  By following these steps, you should be able to address the CM_SUB_INFOSYS021 error and manage manual reductions in your SAP queries more effectively.