Essbase Statistics

The following Essbase-related data is available:

  • Number and type of Essbase operations each hour.
    Section of the Activity Report that displays the number of Essbase operations performed each hour

  • Duration of Essbase operations each hour.
    Section of the Activity Report that displays the duration of Essbase operations for each hour

  • Top 10 Essbase queries that were executed for the longest durations.
    Section of the Activity Report that shows the top ten Essbase queries by duration.

  • Top 10 most frequently run Essbase queries.
    Section of the Activity Report that shows the top ten Essbase queries by execution

  • Top 10 Essbase queries that took over 15 seconds to execute.


    Section of the Activity Report that shows the top ten worst performing Essbase queries that took more than 15 seconds to finish
    Analyzing the Essbase queries listed in this section helps you optimize the process to improve performance.