Using the Performance Analysis Report

It is possible to quickly access performance statistics for individual widgets when creating a story. This information can provide immediate feedback to help create more efficient stories. You can analyze frontend, network, and backend time of the data source related to the widget. The Performance Analysis Report shows data source-specific warnings or recommendations.

The query analysis is available in Optimized Design Mode for charts, tables, and value driver trees where the query runtime in the back-end system is greater than 1 second.

In edit mode of a story, you can open the Performance Analysis Report dialog from the context menu for the widget. In the example below, you can see the menu path for a table. Launch the report by going to More Actions → Applied to Table → Warnings & Errors → Show Performance Analysis. The menu path is the same for value driver trees, however, for tables, a warning icon is shown when the performance analysis is available.

For charts, you would launch the report by going to More Actions → Applied to Chart → Warnings & Errors → Show Performance Analysis.

The Performance Analysis Report can vary, however, the main function is to analyze the widget performance for frontend, network, and backend times. Issues that are found are broken down into high, medium, and low impact groups. The impacts and any recommendations that appear are based on the system that you use.

You can view additional information related to the frontend, network, and backend times by selecting the relevant Information icon.

The report aims to provide additional support to the story designer, but it's not meant to be the only tool used in performance analysis of a story. Query analysis on widget level should be used together with other tools reports, and best practices in SAP Analytics Cloud.

You can find further information in the SAP Analytics Cloud - Widget Analysis post in Technology Blogs by SAP.