SAP Knowledge Base Article - Public

3448924 - Error 'The single measure is only supported in the "RESULTLOOKUP' when saving a data action

Symptom

  • When attempting to save/validate a data action with multiple measures the error “The single measure is only supported in the "RESULTLOOKUP" function for the variable” is displayed.
  • Example of script snippet:

MEMBERSET [d/Measures]=("Amount","Quantity","Price")

IF RESULTLOOKUP() >0 THEN

....

ENDIF

 

Environment

  • SAP Analytics Cloud (Enterprise)

Cause

  • It's not currently supported to use multiple measure filters.
  • If user tries to define a script similar to the one in the symptom of this note general error message “The single measure is only supported in the "RESULTLOOKUP" function for the variable” is displayed.
  • It is a intended behavior.
  • Internally, it was not considered to support measure model concept. Because it is most expensive calculation operation in backend. (Same with aggregation of multiple dimensions).

Resolution

  • It's still recommended to raise an enhancement request to to support this despite its high ressources cost.

See Also

SAC , SAP analytics cloud planning , data action , validation ,  save ,  error , measure , measures , RESULTLOOKUP

Keywords

KBA , LOD-ANA-PL-AF , Advanced Formulas , Problem

Product

SAP Analytics Cloud all versions