How To Fix RMSC023 - Output of formula is a stream; compliance check not possible

RMSC023 - Overview

• Message type: E = Error

• Message class: RMSC - Message Class for Compliance Check in the RM Workbench

• Message number: 023

• Message text: Output of formula is a stream; compliance check not possible

What causes this issue?

You tried to check a formula or a recipe with a formula that contains a
stream as an output item. However, it is not possible to perform the
compliance check for output items that are streams.

System Response

The system does not perform the compliance check.

How to fix this error?

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

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

RMSC023 - Details

• The SAP error message RMSC023, which states "Output of formula is a stream; compliance check not possible," typically occurs in the context of SAP's Business Warehouse (BW) or SAP Analytics Cloud (SAC) when dealing with calculated key figures or formulas in queries or data models. This error indicates that the output of a formula is a stream (i.e., a continuous flow of data) rather than a single value, which makes it impossible to perform a compliance check.
  
  Cause:
  
  Formula Output Type: The formula you are using is designed to produce a stream of data (e.g., a time series or a set of values) rather than a single scalar value. Compliance checks usually require a single value to validate against certain criteria.
  Incorrect Formula Logic: The logic within the formula may be incorrectly set up, leading to an output that is not compatible with the expected input for compliance checks.
  Data Model Configuration: The data