SAP Knowledge Base Article - Public

3365888 - Intersecting Calculations Priority does not work as expected in SAP Analytics Cloud (SAC)

Symptom

In the SAC table, a frontend calculation is added in the row and a calculated measure is added in the column.

In the builder panel of this table, option Intersecting Calculations Priority is set to Columns Override Rows. 

In the intersection cell, the expectation is that the calculated measure to take priority over the frontend calculation. However, it is not happening.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Open the story.
  2. Check the option Intersecting Calculations Priority.
  3. Check the value of the intersection cell.
  4. The value of the intersection cell does not comply with the selected Intersecting Calculations Priority option.

Cause

For calculated measure is a story calculation and the one on rows is a client calculation.

In this case, the intersection priority feature does not work as this feature only works between client calculation and cannot mixed up with other kinds of calculations. 

Resolution

This is the current design.

As workaround, please

  1. create a client calculation next to the calculated measure and refer to the calculated measure via "=<cell ID>"
  2. hide the calculated measure
  3. set 'Intersecting Calculations Priority' to 'Columns Override Rows'

See Also

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, 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, Rows Override Columns, Unresolved , KBA , LOD-ANA-TAB , Table , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

Product

SAP Analytics Cloud all versions