SAP Knowledge Base Article - Public

3000757 - d/<DimensionName> do(es) not exist (in all hierarchies) error when you save a model after modifying an attribute / property of a dimension in SAP Analytics Cloud

Symptom

The following error occurs when you save a model after modifying an attribute or property of a dimension in SAP Analytics Cloud (SAC):

  • d/<DimensionName> do(es) not exist (in all hierarchies).

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.8

Reproducing the Issue

  1. Create model.
  2. Modify one of the attributes or properties of the model (hidden / not hidden).
  3. Save the model.

Resolution

This issue is resolved in 2020.21.11.

This error occurs if you change a property / attribute of an account dimension member (e.g. hide, scale, account type, shift, formula, aggregation type, exception aggregation type etc.) for an account having one of the following complex formulas: LOOKUP, Restrict, SMA, YoY, CAGR.

Workaround:

  1. Copy the formula to your clipboard or a text file using Ctrl-C (keyboard command).
  2. Delete the formula from the dimension grid cell for this account (don't forget to copy it with CTRL-C before).
  3. Save the model.
  4. Change the rqequired account properties.
  5. Click save.
  6. Paste the formula again into the formula cell using Ctrl-V (keyboard command).
  7. Click save.

See Also

Your feedback is important to help us improve our knowledge base.

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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, Error when trying to remove an attribute, attributes, properties custom properties by selecting Create New Property, SAC Model - Error when trying to remove "currency" from certain Member Id's, SAC Model - Error when trying to remove "currency" from certain Member Id's , KBA , account dimension does not save and cann , does not save and cannot change , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-ML , SAC Modelling , Problem

Product

SAP Analytics Cloud 1.0