SAP Knowledge Base Article - Public

3425728 - Validation error after a model change - account dimension reset Aggregation Type

Symptom

After saving a change in a model, for example changing a version attribute, a validation error is shown reporting the below error:

"You have errors in the following members" in dimension <Dimension_name>.

At <Dimension_name> dimension the error:

"Aggregation Type 'None' is not allowed when having Currency Conversion enabled.
Please use Exception Aggregation Type 'None' instead."

is displayed in several members, although they had Agregation Type defined before the modification.

If the page is refreshed, the 'Aggregation Type' is recovered for the members which were in error message and it's possible to make another modification in the model.

Environment

SAP Analytics Cloud 2023.21.16

Reproducing the Issue

  1. access tenant;
  2. navigate to modeler;
  3. open a model;
  4. navigate to a dimension which has Aggregation Type set;
  5. see, for example, column Aggregation type > is set to 'SUM' (for example);
  6. navigate back and open another dimension;
  7. change the value of an attribute;
  8. save it;
  9. notice that there are validation error in the top;
  10. click on it and open related object checked on step 4;
  11. notice that column 'Aggregation type' has changed all values to NONE;
  12. refresh page;
  13. all values become back to SUM (same as set on step 5);

Cause

This issue is under investigation by our development team.

Resolution

This issue is under investigation by our development team.

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, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, aggregation type , KBA , LOD-ANA-ML , SAC Modelling , Problem

Product

SAP Analytics Cloud 1.0