SAP Knowledge Base Article - Public

3447959 - After tenant upgrade for QRC1 model formula is showing validation error in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

Customer is receiving the following validation error for their formula:

  • Formula could not be computed. Account member YYY having exception aggregation cannot be used as the target of inverse. Account member with exception aggregation "Count Count (without unbooked values). Count (without unbooked and zero values)' cannot be used in an Inverse formula Please complete or rewrite the formula.
  • The exception aggregation type is set to None in this scenario.
  • The same was working before the version upgrade.

Environment

SAP Analytics Cloud Version 2024.2.8

Reproducing the Issue

  1. Log on to SAC.
  2. Open affected model.
  3. Switch to calculation view.
  4. Notice that certain formulas are throwing the error.

Cause

The issue has been resolved by Development team.

Resolution

The fix is deployed with patch 2024.2.15.

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,
, KBA , LOD-ANA-ML-CAL , Calculation Management , LOD-ANA-ML , SAC Modelling , LOD-ANA-PL , Planning , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0