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.
- SAP Analytics Cloud (Enterprise) 2020.21.6
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.
To include these members, use the INCLUDE_MEMBERS_NOT_IN_HIERARCHY syntax:
- CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY [ModelName] = [d/DimensionName]
--> Global Configuration Functions
----> 4. CONFIG.HIERARCHY
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