SAP Knowledge Base Article - Public

2992839 - Cannot use member 'XXX' because it is not in the hierarchy in the advanced formula in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error occurs when you save an data action with advanced formulas in SAP Analytics Cloud for Planning (SAC):

  • Cannot use member 'XXX' because it is not in the hierarchy.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.6

Cause

If you specify a hierarchy that doesn’t contain all the dimension members, the "Not in Hierarchies" member and its children are excluded from the calculation scope by default.

Resolution

 To include these members, use the INCLUDE_MEMBERS_NOT_IN_HIERARCHY syntax:

  • CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY [ModelName] = [d/DimensionName]

See Also

  • https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/afe93e3cf1414a7b8419baad11cc066e.html#loioafe93e3cf1414a7b8419baad11cc066e__global_config_func
    --> Global Configuration Functions
    ----> 4. CONFIG.HIERARCHY

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-PL-AF , Advanced Formulas , Problem

Product

SAP Analytics Cloud 1.0