SAP Knowledge Base Article - Public

2728231 - Validation of Advanced Formula returns "Member not found" error in level-based hierarchy in SAP Analytics Cloud (SAC)

Symptom

Issue: when referencing a level-based hierarchy in a MEMBERSET = BASEMEMBER statement validation returns error "Member not found" if selecting first level member. Selecting second level member validates without error.

Issue seems to be only in validation as the formula in both cases returns data in a story.

Environment

  • SAP Analytics Cloud 2018.22.1

Reproducing the Issue

  1. Create a dimension with a level-based hierarchy
  2. Create a Data Action and add an Advanced Formula action.
  3. Add a MEMBERSET function referencing the BASEMEMBER of the level-based hierarchy: MEMBERSET [d/DimensionName]=BASEMEMBER([d/DimensionName].[h/HierarchyName] ,"[FirstLevelMember]" )
  4. Validate. You will get the error "Member '[FirstLevelMember]' not found.
  5. Now modify the BASEMEMEBER and reference a second level member: MEMBERSET [d/DimensionName]=BASEMEMBER([d/DimensionName].[h/HierarchyName] ,"[FirstLevelMember].[SecondLevelMember]" ) and validate.
  6. This will succeed without error

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.

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