How To Fix RSDODSO158 - Referenced key figure &1 is not appropriate in DS (no BEx Reporting)

RSDODSO158 - Overview

• Message type: E = Error

• Message class: RSDODSO - Messages for ODS Objects

• Message number: 158

• Message text: Referenced key figure &1 is not appropriate in DS (no BEx Reporting)

What causes this issue?

You are using the &V1& referenced key figure in the &V2& DataStore
object. The DataStore object &V2& is not permitted for BEx reporting.

System Response

The key figure &V1& is not kept on the database. It is only filled for
the query runtime using the OLAP process from the
<DS:DE.RSDCHABASNM>reference key figure</>. Subsequently, the OLAP
processor calculates differently with this key figure than with the
reference key figure (for example, the &V1& referenced key figure can
have another aggregation as its referenced key figure).
Since no BEx queries can be defined for the DataStore object &V2&, it
does not make sense to include the referenced key figure &V1&.

How to fix this error?

Activate BEx reporting for the DataStore object &V2&, or remove the
referenced key figure &V1 from the DataStore object.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDODSO158 - Referenced key figure &1 is not appropriate in DS (no BEx Reporting) ?

  The SAP error message RSDODSO158 indicates that a key figure referenced in a DataStore Object (DSO) is not suitable for use in Business Explorer (BEx) reporting. This typically occurs when the key figure is not defined correctly or is not compatible with the reporting requirements in the BEx environment.
  
  Cause:
  
  
  Key Figure Configuration: The key figure may not be set up correctly in the DSO. This could include issues such as:
  
  The key figure is not marked as "reportable."
  The key figure is defined with incompatible data types or aggregation settings.
  The key figure is not included in the relevant InfoObject catalog.
  
  
  
  Data Model Issues: The DSO may have been designed in a way that does not align with the reporting needs, such as missing necessary key figures or dimensions.
  
  
  BEx Query Design: The BEx query may be referencing a key figure that is not available or not suitable for reporting due to the DSO's configuration.
  
  
  
  Solution:
  
  
  Check Key