The Benchmark Performance dialog displays information relating to the performance of the query, including the time taken for the query to run, and the number of columns, rows, and cells in the query. This information enables the user to review the query performance and assess whether there may be a performance issue by comparing the query time with the query size.
Access the Performance dialog
Click the Clock icon at the bottom-right of the page (green arrow below) to open the Performance dialog.
Note: This feature is only enabled if Benchmark Logging is enabled in the Log Settings. This option is set in the Admin console.
Performance dialog information
The Performance dialog displays information about the query's performance:
- Pyramid Time: Pyramid's processing time. This is split into server processing time and client processing time.
- Network: The time it takes to get from the server to the client.
- Query Time: The time it takes to run the query (this is dependent on the data source).
- Total Time: The total time to run the query.
- Columns: The number of columns in the query.
- Rows: The number of rows in the query.
- Cells: The number of cells in the query.
Query Text dialog
Click the Code icon </> (orange arrow above) at the top of the Performance dialog to open the Query Text dialog, where the MDX syntax that underlies the query is displayed and can be copied to your clipboard.
Note: If caching is enabled, you may see the message "Query Cache" in the Query Text window. To resolve this, close the window and disable the cache using Cache Options > Disable Cache on the Query ribbon. For more information, see Query Settings.