Optimize System Performance with the Analysis Tool
As an administrator of an SAP Analytics Cloud tenant, you can use the Performance Analysis Tool and the decision tree below to find resources that will help you resolve performance issues.
- Users with Read and Update permissions for System Information.
- Admin and BI Admin
The following instructions apply primarily to SAP Analytics Cloud (public and private). Some sections may also be applicable to SAP Analytics Cloud, Embedded edition depending on feature availability.
Use the Performance Decision Tree
Follow the steps in the following decision tree to find resources that will help you to resolve performance issues.
This image is interactive. Hover over each area for a description. Click highlighted areas for more information.
Run the Performance Analysis Tool
Context
The Performance Analysis Tool identifies processing time by document for three major areas: Network, Frontend, and Backend. Based on the problem area, you can access the appropriate KBAs, Best Practice documents, and Help articles to support you in making performance improvements.
Procedure
- To open the Performance Analysis Tool, choose .
-
To set the date range:
- Click the Session Date token.
- Adjust the existing range or add a new range.
- Click OK.
-
To apply additional filters:
- Click (Set Filter) and select Resource or User.
- Select the appropriate member(s).
- Click OK.
- Click Search.
- In the list of results, click to select the document to analyze.
- Click the Runtime Distribution tab.
Results
Find Resources
Browser/Client Optimization
To optimize your browser/client:
-
Ensure your computer is plugged into a power outlet
-
Check if the issue can be reproduced after closing all other browser windows, tabs, and applications
-
Check if the issue can be reproduced when not teleconferencing, screensharing, screen recording, or playing video or audio
-
Check if the issue can be reproduced when using a physical computer, rather than a virtual machine, if applicable
-
Benchmark your client’s score, as well as the latency and bandwidth to your SAP Analytics Cloud service: Analyze System Performance and SAP Analytics Cloud Performance Benchmark
-
Check if the third-party proxy is forcing the browser to use HTTP 1.1 instead of HTTP/2: 3056467 - Slow performance when accessing / consuming content in SAP Analytics Cloud (SAC)
-
Verify that your system meets the appropriate system requirements: System Requirements and Technical Prerequisites
-
Enable the “High Performance” power plan on the desktop that is accessing SAP Analytics Cloud: 2327454 - Low performance occurs in tables / grid and other areas of SAP Analytics Cloud
-
Generate an HTTP archive (HAR) file to help troubleshoot system errors and performance issues in SAP Analytics Cloud: 2280022 - How to collect a HTTP archive (HAR) file (Chrome developer tools network trace) in SAP Analytics Cloud
-
Analyze the performance of a Chrome page using Chrome DevTools: Performance features reference
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
Analytic Application Optimization
To optimize Analytic Applications:
-
Review and apply the best practices in Chapter 14 of the Developer Handbook to improve application performance of your apps: SAP Analytics Cloud, Analytic Designer – Developer Handbook
-
Review and apply additional best practices: Performance Best Practices for SAP Analytics Cloud, Analytic Designer and Best Practices for Performance
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
Story Optimization
Stories contain multiple widgets that can be optimized individually.
Stories
To optimize stories:
-
Limit the number of widgets on a page
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
Charts
To optimize charts:
-
Limit the number of charts on the page to enhance readability, decrease the number of backend requests, and improve performance
-
Avoid charts with more than 500 data points
-
Be aware of progressive chart rendering, which enables chart widgets to display more quickly when a story is opened a subsequent time: 2604574 - Charts in stories open significantly faster the second time in SAP Analytics Cloud
-
Apply the Top N feature to charts as described in the Top N Improvements section: What’s New in SAP Analytics Cloud and SAP Digital Boardroom Release 2018.12
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
Tables
To optimize tables:
-
Limit the number of tables on the page to enhance readability, decrease the number of backend requests, and improve performance
-
Limit the number of cells in tables
-
Enable the “High Performance” power plan if scrolling in tables is slow: 2327454 - Low performance occurs in tables / grid and other areas of SAP Analytics Cloud
-
Apply the Top N feature to tables as described in the Top N Improvements section: What’s New in SAP Analytics Cloud and SAP Digital Boardroom Release 2018.12
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
Geo Maps
To optimize geo maps:
-
Reduce the number of data points displayed on maps
-
Enable location clustering for 1,000+ points, instead of the default of 5,000+ points
-
Construct the layout of maps to limit zooming and panning if location clustering is enabled, as each movement submits a backend query
-
Apply best practices to geo maps that take longer than a minute to load: 2676310 - Story with geo-map loading slowly in SAP Analytics Cloud (SAC)
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
Filters and Input Controls
To optimize filters and input controls:
-
Apply best practices to filters as described in the Filters sections: Best Practices for Performance
Images
To optimize images:
-
Use the SVG format instead of PNG, JPG, or BMP
-
Leverage header images, whenever possible
-
Use Fiori Styles/Fonts instead of images
Mobile App
To optimize stories for the Mobile app:
-
Check that you have the appropriate network speed and meet the specific device requirements for the SAP Analytics Cloud Mobile app: 2699872 - How to improve performance in the SAP Analytics Cloud (SAC) mobile app for iOS
Other
To optimize other elements:
-
Reduce the number of queries and enable optimized viewing: Optimized Story Experience
-
Consider tips in the Performance Improvement section related to Active Viewport Rendering and Optimized View Mode: Experience Performance and Usability Improvements with SAP Analytics Cloud Stories
-
Apply additional best practices: Best Practices for Performance
-
Do some more investigation into the cause of the issue: How to Isolate a Performance Issue in SAC Stories?
-
Activate the HTTP/2 protocol. Note that this can lead to issues if the backend is unable to handle the increased load, so consider the trade off of using this option: HTTP/2 Support
Planning and Data Action Optimization
To optimize planning workflows and data actions:
-
Apply best practices for designing planning models: SAP Analytics Cloud for Planning: Modeling checklist
-
Apply best practices for using calculations: SAP Analytics Cloud for Planning: Optimizing Calculations
-
Adjust calculations to incorporate calculation scope and optimum use of FOREACH, IF, and RESULTLOOKUP functions: Optimize Advanced Formulas for Better Performance
-
Apply best practices for the planning area:
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
Network Optimization
To optimize the network:
-
Check the reverse proxy, VPN, and wireless network
-
Check if the issue can be reproduced without VPN, if permitted by company policy
-
Check the network conditions on SAP Data Centers to determine if there are critical outages:
-
Check if the third-party proxy is forcing the browser to use HTTP 1.1 instead of HTTP/2: 3056467 - Slow performance when accessing / consuming content in SAP Analytics Cloud (SAC)
-
Generate an HTTP archive (HAR) file to help troubleshoot system errors and performance issues: 2280022 - How to collect a HTTP archive (HAR) file (Chrome developer tools network trace) in SAP Analytics Cloud
Backend Optimization
The connection type impacts the resources available to assist with addressing performance issues.
SAP HANA Live
To optimize SAP HANA live connections:
-
Apply best practices for SAP HANA Live connections: SAP Analytics Cloud – HANA Live Connection Best Practices
-
Use information views in performance analysis mode to check the performance impact at runtime of calculation views: Open Information Views in Performance Analysis Mode
-
Consider tips and tricks to improve performance of SAP Analytics Cloud with live SAP HANA connections: HANA live performance
-
Use Implicit SQL optimization of SAP HANA Calculation Views: 2223597 - Implicit SQL optimization of SAP HANA Calculation Views
-
Take advantage of enhancements to the query analytic processing engine inside HANA, which is enabled in SAP HANA Cloud but disabled in SAP HANA 2.0: 3139162 - EPMMDS: New processing Engine (CPC)
-
Avoid joins on calculated objects when SAP HANA live connections are used
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
SAP Universe Live
To optimize SAP universe live connections:
-
Apply best practices for live universe connections:SAP Analytics Cloud – Live Universe Consumption (LUC) Best Practices
SAP BW Live
To optimize SAP BW live connections:
-
Apply best practices for SAP BW live connections: SAP Analytics Cloud – BW Live Connection Best Practices
-
Review how to measure performance with live BW scenario: BW Live Connectivity Performance
-
Optimize SAP BW queries:
-
Achieve a significant runtime gain by using "Values in Master Data Table": 2245483 - Long runtimes for input help - read mode "Only Values in InfoProvider"
-
Evaluate M-Mode, D-Mode and Q-Mode for trade-off of convenience versus performance: 1565809 - BW Query Input(F4) Help: Settings and Properties
-
Enable traces to evaluate performance impact:
-
Review and apply best practices on SAP Community: https://community.sap.com/topics/cloud-analytics/best-practices-troubleshooting
SAP BW/4HANA
To optimize SAP BW/4HANA connections:
-
Choose the right mode to ensure optimized operations can be performed: Optimizer for Operations in SAP HANA
SAP S/4HANA
To optimize SAP S/4HANA connections:
-
Find best practice documentation for SAP S/4HANA: 2748973 - Where can I find more information on SAP S/4HANA Cloud / SAP S/4HANA On-Premise and SAP Analytics Cloud integration best practices?
SAP Data Warehouse Cloud
To optimize SAP Data Warehouse Cloud connections:
-
Use the HANA Plan Visualizer: Troubleshooting SAP DWC Performance Issues with the HANA Plan Visualizer
-
Apply best practices for SAP Data Warehouse Cloud connections: Best Practices and Troubleshooting
-
Run in Analytics Mode to optimize performance: Perspective in Analytics Mode
-
Create statistics for your remote tables to provide efficient query execution plans: Creating Statistics for Your Remote Tables
Data Acquisition
To optimize data acquisition:
-
Increase the maximum memory allocation for Apache Tomcat: 2732879 - Modify SAP Analytics Cloud agent Apache Tomcat memory allocation for Tomcat7_SACAgent
-
Apply best practices to troubleshoot data acquisition issues: 3158133 - SAP Analytics Cloud Best Practice - How to analyze relavant traces to help troubleshooting issue - Set up data acquisition
-
Review data integration limits for models, datasets, and stories: System Sizing, Tuning, and Limits
Other
To optimize other connections:
-
Review security recommendations for live connections: SAP Analytics Cloud – Live Connection and Security – Best Practices
-
Apply best practices for exporting to CSV and Microsoft Excel: Best Practices for SAP Analytics Cloud CSV and Excel export performance
Other
Here are some additional resources that may be helpful: