SAP Knowledge Base Article - Public

3000381 - ResultLookup from default (empty) Date member not working correctly in SAP Analytics Cloud (SAC)- 2020.21.8


The following error message occurs in SAP Analytics Cloud (SAC) when validating Data Action:

  • DateForm: Cannot use member " because it is not in the hierarchy.

The Date type dimensions are populated by the system and cannot be manually edited.
In the case where two date type dimensions are created, we see: the "DateFrom" and "DateTo".
In planning tables, if you don't specify a specific member normally it saves your data on the hash (#) member but for additional date dimensions, it posts to empty members (please see word doc attached).
However, once it does, you cannot use that data anymore in RESULTLOOKUP() formula


  • SAP Analytics Cloud (Enterprise) 2020.21.8

Reproducing the Issue

1.Open data action 
2.Validate it


This issue is a bug.


The fix is planned for SAC version 2021.01 and 2021.02(QRC release).

See Also

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


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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-PL-DA , Data Actions , Bug Filed


SAP Analytics Cloud 1.0