SAP Knowledge Base Article - Public

2792311 - RESULTLOOKUP formula returns message "Member must be a leaf member" if member is not base level in SAP Analytics Cloud (SAC)

Symptom

RESULTLOOKUP formula in Advanced Formula returns message "Member must be a leaf member" if member is not base level.

Environment

  • SAP Analytics Cloud 2019.9

Reproducing the Issue

  1. Create a new Data Action
  2. Add Advanced Formula step
  3. Add a RESULTLOOKUP formula that references a parent member.

Cause

This is a current restriction of Resultlookup function in Data Action.

The feature to Support Parent/Formula member in Resultlookup in Data Action is in our backlog for future consideration.

Resolution

The workaround for the moment is to manually calculate sum of all the children members in the Data Action.

See Also

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