SAP Knowledge Base Article - Public

2888934 - Data Action - filter on version not possible if ATTRIBUTE is also specified in SAP Analytics Cloud for Planning (SAC)

Symptom

It is not possible to save a Data Action with a RESULTLOOKUP function referencing both the version and an attribute of a dimension:

i.e.: RESULTLOOKUP([d/Version]="public.Actual")/ATTRIBUTE([d/Time].[p/CALWEEK])

Environment

  • SAP Analytics Cloud (Enterprise) 2020.02 and earlier releases

Reproducing the Issue

Create a Data action with a RESULTLOOKUP function referencing both Version and an attribute of another dimension:

RESULTLOOKUP([d/Version]="public.Actual")/ATTRIBUTE([d/Time].[p/CALWEEK])

Try to save the data action. You will not be able to

Cause

This issue is due to a bug in the SAC code regarding the combination of both version and an attribute in a RESULTLOOKUP. If you remove the Attribute the Data Action will save and execute successfully.

Resolution

This issue is resolved in 2020.03 and later releases

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, RESULTLOOKUP , KBA , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0