SAP Knowledge Base Article - Public

2837944 - Account dimension shows error and cannot be saved in SAP Analytics Cloud (SAC)

Symptom

  • Account type dimension suddenly throws validation error and cannot be saved.
  • When opening the dimension the "Account Type" column shows errors and hovering over a member shows pop up "Rate Type Should be AVG(Average) for INC(Income) and EXP(Expense) account types".
  • However there is no "Rate Type" column in the dimension.

Environment

  • SAP Analytics Cloud 2019.18 and earlier

Reproducing the Issue

  1. Create a model with public account dimension and some dimensions with currency column
  2. Enable currency for this model
  3. Save the model
  4. Create a second model with the same account dimension and some dimensions with currency column (can be the same if it was public)
  5. Enable currency for the model and close the dialog (but do not save)
  6. Disable currency for the model --> Rate type column gets removed
  7. Save the model

Cause

Rate Type column is only added to an Account type dimension if currency conversion is enabled.

As the code validates this condition each time a model is created, if the last model to use a public Account dimension does not have currency conversion the existing Rate Type column is removed.

This issue will be fixed in a later release.

Resolution

The following workaround can be used to to re-add the column:

  1. Create a "dummy"-model with the account dimension and some dimension with currency column
  2. Enable currency for this model --> Rate type column gets added
  3. Save the model (which saves the dimension)
  4. Delete the dummy-model

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 , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning Functionality, Planning Models , Problem

Product

SAP Analytics Cloud 1.0