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
- Open the story.
- Check the option Intersecting Calculations Priority.
- Check the value of the intersection cell.
- 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
- create a client calculation next to the calculated measure and refer to the calculated measure via "=<cell ID>"
- hide the calculated measure
- set 'Intersecting Calculations Priority' to 'Columns Override Rows'
See Also
- Intersecting Calculations Priority part on the SAC online help
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.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://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