Essbase Runtime Data

The following Oracle Essbase runtime data may be available in the Activity report:

• 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.
• The following Essbase runtime metrics.

Table 11-2 Essbase Runtime Metrics

Essbase Runtime Metric	Description
Essbase Requests Duration in Minutes	Total execution time of Essbase activities in the last 24 hours.
Average Essbase Calc Execution Duration in Seconds	Average time, in seconds, taken to run Essbase calculations in the last 24 hours.
Longest Essbase Calc Execution Duration in Seconds	Time, in seconds, taken by the longest running Essbase calculation in the last 24 hours.
Average Essbase Data Load Duration in Seconds	Average time, in seconds, taken by the Essbase data load activities in the last 24 hours.
Average Essbase Restructure Duration in Seconds	Average time, in seconds, taken by the Essbase restructure operations in the last 24 hours.
Average Essbase Spread Sheet Extraction Duration in Seconds	Average time, in seconds, taken by the Essbase spread sheet extraction activities in the last 24 hours.
Longest Essbase Query Duration in Seconds	Time, in seconds, taken by the longest running Essbase query in the last 24 hours.
Average Essbase MDX Query Execution Duration in Seconds	Average time, in seconds, taken by the Essbase MDX query executions in the last 24 hours.