SAP Knowledge Base Article - Public

3334167 - Overall system performance issues when multiple users are doing planning in SAP Analytics Cloud (SAC)

Symptom

You experience overall system performance issues when multiple users are doing planning processes in SAP Analytics Cloud (SAC).
We identified some repetitive problems, such as:

  • System slowness / Non responsive
  • Users were unable to copy-paste data in tables
  • Story/page filters grayed out
  • Unable to Publish data

If you capture the HAR file as per KBA 2280022, you will find warnings indicating that performance-reducing settings have been detected in the model and story. For example,

  • The query filter is a hierarchical filter, but is converted to a flat filter with xxxxx elements. This may decrease performance
  • The member xxxx has 10 exception aggregation dimensions. More dimensions result in larger data volumes and decreased performance
  • The request contains a large number of calculation entities (xx) and  xxxx% of them (xx) are hidden

Environment

  • SAP Analytics Cloud

Cause

There is a higher system load detected caused by a combination of different reasons. 

  • There are many public edit versions created, for example, in total 221 and each public edit version uses 2 - 2,5 million facts.
  • Many users are using the public edits of a version simultaneously that causes a high load on the system. These public edits are created in the story before any data entry or change can be done. 
  • As indicated by the warnings in the HAR file, you are using a too high overall complex scenario. 

Resolution

Please try to optimize your model and story to reduce the complexity which is causing the expensive requests and therefore such long runtimes.

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, slowness , KBA , LOD-ANA-XUS , User assistance, performance statistics , LOD-ANA-PL-VER , Version Management , Problem

Product

SAP Analytics Cloud 1.0