SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.8

Reproducing the Issue

1.Open data action 
2.Validate it

Cause

This issue is a bug.

Resolution

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.

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, 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

Product

SAP Analytics Cloud 1.0