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 worst performing Essbase data extraction operations.
    Section of the Activity Report that shows the top ten worst performing Essbase data extraction operations

    Information in this table includes the start and end time, and cube from which data was extracted for each operation in the table. Depending on the total duration , you may need to evaluate and streamline these operations to improve performance.

  • Top 10 worst performing Essbase data load operations.
    Section of the Activity Report that shows the top ten worst performing Essbase data load operations
  • Top 10 worst performing Essbase restructure operations.
    Section of the Activity Report that shows the top ten worst performing Essbase restructure operations
  • 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

    Many important pieces of information are available in the Context column in this table. The number of blocks read and the number of output cells of the query gives an indication of the amount of data being requested. The number of formulas executed is an indication of the formula intensity on the query. The number of odometers is an indication of the asymmetric layout of the query.

    Analyzing the Essbase queries listed in this section helps you optimize the queries to improve performance.
  • 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

Additionally, the following Essbase runtime-related data may be available:

  • Last 15 Clear Data Commands, which identifies the user who ran the operation, the affected cube, the calculation script, and the commands in the calculation script that resulted in clearing of the data.
  • Last 15 Clear Block Commands, which identifies the user who ran the operation, the affected cube, the calculation script, and the commands in the calculation script that resulted in clearing of blocks.
  • Essbase runtime metrics.
  • Essbase Design metrics.
  • Essbase BSO Cube Statistics, such as total number of dimensions, including the number of dense and sparse dimensions, number of level 0 and upper level blocks.
  • Dimensions in BSO Cubes, including the dimension name, type, and number of declared and stored members.
  • Essbase ASO Cube Statistics, such as total number of dimensions, including the number of input-level cells, aggregate cells, and incremental data slices.
  • Dimensions in ASO Cubes, including the dimension name, hierarchy type of Gen2 members, and number of declared and stored members.