SAP Knowledge Base Article - Public

2648354 - Incorrect data shows when using ResultLookUp function in SAP Analytics Cloud

Symptom

  • Incorrect data shows when using ResultLookUp function in SAP Analytics Cloud

Environment

  • SAP Analytics Cloud 2018.08.02

Reproducing the Issue

  1. Create a story contains a table with dimension and account.
  2. Add a ResultLookUp calculated measure. For example, return values of Sales Revenue for CATEGORY ="Boatwear".
    1.png
  3. Note that in the cell that CATEGORY !="Boatwear", it still shows value.
    2.png

Cause

ResultLookup is working as designed. This function will copy cell value of "Category ID=Boatwear" into all cells of  resultLookup column.

Resolution

Using restricted measures would be an alternative solution for the expected behaviour.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud 1.0