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