SAP Knowledge Base Article - Public

2732730 - LOOKUP formula that references another formula does not return data in SAP Analytics Cloud (SAC)

Symptom

When creating an account member formula with a LOOKUP statement that references another formula account member, no data shows in a story.

The same type of formula that references a non-formula member works as expected.

Environment

  • SAP Analytics Cloud 2018.19.5

Reproducing the Issue

  1. Create an account dimension member with formula: LOOKUP([AMOUNT],[d/Time]=Previous("Month",12))
  2. Account member AMOUNT has no formula - standard input account
  3. Create another account member with formula: LOOKUP([ALLBW],[d/Time]=Previous("Month",12))
  4. Member ALLBW has formula [AMOUNT]

The first member will show data as expected but the second member does not.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

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

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

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 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) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0