SAP Knowledge Base Article - Public

2511489 - Troubleshooting performance issues in SAP Analytics Cloud (Collective KBA)

Symptom

Environment

SAP Analytics Cloud

Cause

There are multiple reasons why performance may be affected. This collective Knowledge Base Article (KBA) describes how to collect more information, how to test your network, browser, stories, data actions and apps (applications written with SAC's application designer) and provides further resources to help you overcome performance issues.

Resolution

The overall performance of SAP Analytics Cloud (SAC) is mainly determined by the three components - client time (frontend), network time and the SAP Analytics Cloud service time (backend):

  • The performance of the frontend (client time) is affected by other applications running on your computer. If you have other CPU intensive applications/processes like video conferencing software running in parallel, that will have an impact on other CPU-intensive calculations in SAC like rendering of multiple thousands of cells in a table.
  • The performance on the network is similarly affected by other applications consuming the bandwidth and by some other potential issues over the network caused by VPN, firewalls, bad internet service provider connections, etc.
  • Regarding the backend (SAP Analytics Cloud service time), there is a finite amount of hardware available and multiple concurrent users triggering expensive computations in parallel will slow down processing and have a perceived effect of the overall performance of the system.
  • By using our Performance Analysis tool, you can identify the problematic parts of your scenario and see how much time is spent in which component (frontend, network, backend).
  • To understand the end-to-end time you're perceiving on the client side as well as any instabilities in the overall time or the differences between the different users, you need to check all three pieces and everything affecting them.
    • Note: This tool only traces the performance of stories, data actions and apps (applications written with SAC's application designer).
    • Other activities and navigation actions such as opening the SAC modeler, etc. are not traced.
  • If you have a story, data action or app where the performance is not optimal, run it more than once and check the results in the performance analysis tool to see where the time is spent and compare it for different user sessions, time stamps and systems (production system, test system, QA system, etc.), if needed, taking the above points under consideration.

End_to_End_Response_Time.png

Troubleshooting steps (reproduce, isolate and document)

  1. Review and analyze your scenario using the Performance Analysis tool (This content helps analyze a single Story, data action or Analytic Application run).
  2. Reproduce the problem (is the issue reproducible?):
    1. on more than one user’s machine (notebook, mobile device)?
    2. on the same notebook on a different network?
    3. on another story with the same connection?
    4. with a different user login?
    5. with both Google Chrome and Microsoft Edge?
    6. after clearing the browser cache (Ctrl + Shift + Delete  / clear browsing data)?
  3. Isolate the source:
    1. When did the problem start happening? If it worked before, what changed?  If it has always been slow, isolate and simplify the story.
    2. If at all possible, reproduce the issue on a responsive layout story, with a single analytic model using data acquired into SAC.
  4. Document clear reproduction steps when a performance issue occurs.

Browser (client)

  • Ensure that no third party proxies or other applications are forcing the client (browser) to use the HTTP 1.1 protocol instead of the HTTP 2 protocol see KBA 3056467.
    • Please note: The HTTP/2 Protocol is currently only supported for Live Data Connectivity between SAC and BW and SAP BPC using HTTPS. For more information on how to enable HTTP 2 Support for these datasources, please see HTTP/2 Support.
    • All Network requests made to the SAC Tenant, will use HTTP 1.1, as HTTP/2 for these requests is not currently supported with neither NEO or Cloud Foundry (CF) landscapes.
  • Perform the same action with a different computer. Your computer may be affected by domain policies, browser settings or specific configurations for your user account.
  • Check if other users in your location also experience the same problem.
  • Confirm that correct client software and client configuration requirements at System Requirements and Technical Prerequisites.
  • Enable "High Performance" power plan of your computer's power option plan. See KBA 2327454 - Low performance occurs in tables / grid and other areas of SAP Analytics Cloud.

Network

Your network connection has a significant influence on your experience. Steps to test your network:

  • Wireless: We all love wireless but it is not as fast as Gigabit ethernet and other network adapters.
  • Reverse proxy: Are you using a reverse proxy to access SAP Analytics Cloud? If so, verify that the behavior also happens when you connect to the public SAC URL and access  the demo stories.
  • Internet connection: Test network latency from your network to SAP Analytics Cloud. Warning! This is only an estimate. Go to the Network Performance Measurement Tool and test the network bandwidth and latency or use the internet speed test Web site of your choice and simulate a connection to the location where your SAP Analytics Cloud data center is located.
  • VPN: Using VPNs may affect performance as you may be tunneling requests to SAP Analytics Cloud via your VPN connection. You can compare the performance when connected directly to your network. If you notice a significant improvement, contact your VPN / IT administrator.

Stories (Canvas / Responsive / Grid pages)

  • Quick win: Best Practice Performance Tips for Story Designers (in design mode) have now been added during story design processes. See the following for more information.
  • Quick win: Enable Optimized View Mode to improve the performance of stories (in certain scenarios) and provides usability improvements. See here, and here.
  • Quick win: Re-save the story to take advantage of incremental improvements since the last update of your system.
  • Quick win: In the model preferences under Data and Performance, toggle on “Optimize Story Building Performance”. This prevents automatic refreshing of data during story design.
  • Simplify story: Use canvas style stories to your advantage. 
  • Chart optimizations: Avoid charts with a large number of data points (>500).
  • Table optimizations: Leverage Explorer instead of using large tables.
  • Images: Resize SVG and PNG files to decrease download times of these files.
  • Linked analytics: Linking too many charts will trigger updating their values every time the selection or filter changes.
  • Settings: Take advantage of Progressive Chart Rendering. See article 2604574 for further information.
  • Blending: Use the "Exclude descendents" option if hierarchies have identical structure & ensure filtering uses currently selected members only (See link dimensions).
  • Geo maps / Geospatial: See KBA 2676310 - Story with geo map loading slowly in SAP Analytics Cloud (SAC) and geospatial best practices.

Analytics Designer

Live Data versus imported data (acquired models)

Data actions and Planning Features (in Planning models)

Capturing performance information in Google Chrome

  • If you have tested all the previous steps and still experience performance problems, please conduct the following so that SAP Product Support can investigate further:
    • Capture a HAR file using the Network tab in Google Chrome Developer Tools. See article 2280022 - How to collect HTTP archive files (HAR) files.
    • Capture a performance trace using the Performance tab in Google Chrome Developer Tools. See article 2413393 for further information.
    • Google Chrome Performance Analysis Reference: Click here
    • Review article 2630653 - How to Troubleshoot and Trace SAP Analytics Cloud connecting to on-premise / acquired / imported data.

SAP Analytics Cloud Performance Analysis Tool

  • The Performance Analysis Tool is now available for reviewing performance metrics for your SAP Analytics Cloud service. For example, comparing the performance of various objects, and their impact on the overall service performance.

Cloud availability center and data center status

  • The Cloud Availability Center offers a personalized dashboard with at-a-glance visibility into cloud product availability. Accurate, up-to-date information into the status of your cloud products, critical information, maintenance updates, notifications, all in one place. Read more about it here.
  • Follow the availability of the platform at the SAP Cloud Platform Status page for real-time and historical data on system performance.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

slow, performance, speed, C4A, BOC, SAC, AnalyticsCloud, Analytics Cloud, SAP BusinessObjects Cloud, network connection, bandwidth, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, slower, Performance problem, stopped, slow, slowness, hangs, hanging, Cross calculation, sac bp performance sap kba, Performance, system slowness, latency, DC issue, data centre, data center, system slow, system performance, SAC performance issues on planning model, We are encountering Unresposive page pages, Unresposives, waiting issues, unresponsive, processing time, very, very slow, processing time, unproductive, Slowness upload, terrible impact, loading, sac, sac, sap analytics cloud planning, sap analytics cloud training, sap analytics cloud tutorial, user assistance, ua, helpdocs, help information, "sac online help", sap analytics cloud help, sap analytics cloud user guide pdf, sap analytics cloud architecture, sap analytics cloud tutorial, sap analytics cloud connections, sap analytics cloud architecture pdf, learning sap analytics cloud pdf, More accessible documentation on your products and more community resources, SAC Tenant Performance Issues, EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, troubleshooting, overview, sap sac, sac, sap analytics cloud planning, sap analytics cloud training, sap analytics cloud tutorial, sac, ua, help, analytics help, support, c4a, boc, analyticscloud, incident, troubleshooting, faq, sac faq, sac help, sap analytics cloud documentation, guides, sac support, sap analytics cloud support, ac, 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, ヘルプ, Hilfe zu, Ayuda para, Ajuda para, sap sac, sac, sap analytics cloud planning, sap analytics cloud training, sap analytics cloud tutorial, planning, sac, Analytics Cloud Onpremis install, SAP analytics cloud, SAP BW, stories, geo, story, Analytics designer, 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, sap analytics cloud, analytics cloud, cloud analytics, analytics, sac, sap analytics cloud for planning, fp&a, collaborative planning, enterprise planning, extended planning, xP&A, extended planning and analysis, financial planning and analysis, connected planning, integrated planning, workforce planning, headcount planning, allocations, value driver tree, VDT, data action, predictive forecasting, smart predict, planning applications, planning model, advanced formulas, strategic planning, Profit and Loss Planning, P&L planning, bottom-up planning, top-down planning, currency conversion, version management, fp&a, predictive analytics, operational plan(s)(ning), financial planning and analysis, planning tools, integrated business planning, xp&a, integrated planning, collaborative planning, planning model (s), connected planning, enterprise planning, budgeting and forecasting software, enterprise planning, planning and forecasting, planning budgeting and forecasting, planning and analysis, enterprise planning software, financial planning and forecasting, sap analytics cloud planning, predictive planning, driver based models, what if planning, enterprise planning cloud, cloud fp&a, Enterprise Planning, Planning, analysis, budgeting, and prediction in one solution, Embedded business intelligence and predictive analytics, Integration with SAP S/4HANA , KBA , sac planning performance slow , sac perf kba perforamnce , oom , experience poor performance , bw4hana s4hana hdb bw4 , custom formula , custom calculation , sum function does not work in table , sac - performance problems on stories , for each loops for eachloops , it's taking over minutes to load taking , slowness , forever , sac production bad performance , performance issue with input story , performance for this story has degraded , how to improve performance in the sap an , sac performancnce kba troubleshooting , geo map loadng stowty in story slowly , users experienced extreme slow performan , experience performace , lazy loading laz lazi rendered , experiencing very low performance , sac , and issues in displaying some tables in , sap analyst cloud, connected, failure, s , fail failed, stopped , geo map loadin slwol story , geo map loading slow story sac kba , very slow performance of sac planning st , stry story , product functional knowledge , optimize their scenarios , experience bad performance , for all our users , message bad gateway , performance issue and bad gateway error , sac production and test environment , poor performance in , performance issues in new foundry tenant , data loads benchmark , neo vs cloud foundry , new foundry tenant , sac kba hana live query , fitlering filtering filters filtered , analyse the lack of performance , performance of sac reports very poor in , impacting month end reporting , very poor in production system , performance is very slow , sac performance issues , very very poor slownesss , "sac tenant performance issues" , sac tenant performance issues , sac tenant data issue , and lagging in rendering and presentatio , presentation of screens and data , stories are slow to open and navigate co , navigate compare to our norm , general slow system wide performance , super slow performance creating stories , sluggish performance of general sac nav , general sac navigation , slow response time for /fpa/ , getresponse slow , performance issue with , performance issue, slow , chart rendering , analytics designer: performance issues, , including slow load loading , performance deteriorates when executing , bw queries in sac analytics application , performance problems - sac , "analytic application low performance" , analytic application low performance , analytic application low performance loa , load-and-ad , performance lod-ana-ad , "performance kba sac" , please restart our system to clear syste , system to clear system degradation , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , LOD-ANA-PL-DA , Data Actions , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud 1.0

Attachments

How to optimize performance for on-premise SAP BW Live connectivity.pdf