SAP Knowledge Base Article - Public

3274300 - resultlookup() statements without further definitions in brackets is not executed and does not return the result after Q4 22 release

Symptom

After Q4 22 release, RESULTLOOKUP() without further definitions in brackets are not executed and does not return the result.   

DATA.APPEND([d/DIMENSION] = "XXXXX") =  RESULTLOOKUP() 

When member set is defined it works. DATA.APPEND([d/DIMENSION] = "XXXXX") =  RESULTLOOKUP([d/DIMENTION] = "YYYYY") 

Environment

SAP Analytics Cloud (Enterprise) 2022.21.7

Reproducing the Issue

Execute a data action which include RESULTLOOKUP() and confirm the result. Example 1 is not excepted therefore it does not return the result. 

Example 1 - DATA.APPEND([d/DIMENSION] = "XXXXX") =  RESULTLOOKUP() 

Example 2 - DATA.APPEND([d/DIMENSION] = "XXXXX") =  RESULTLOOKUP([d/DIMENTION] = "YYYYY") 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

Keywords

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

Product

SAP Analytics Cloud 1.0