Essbase Runtime Data

Last 15 Data Management Clear Data Commands

This table logs recent Clear Data commands from Data Management, helping identify potential causes of data loss and verify alignment with intended activity. The table includes:

Time - The timestamp indicating when the Clear Data command was executed.
Process ID - The unique identifier assigned to the Data Management process that triggered the command.
Command - The full Clear Data command issued.

Last 15 Calc Script Clear Data Commands

This table logs recent Clear Data commands executed through calculation scripts. It helps identify users responsible for the operation, the impacted cube, and the script details that triggered data clearance. The table includes:

User – The user account that initiated the Clear Data operation.
Cube – The name of the cube where the data was cleared.
Calculation Script – The script used to execute the Clear Data command.
Command – The specific command(s) within the script responsible for clearing the data.

Last 15 Calc Script Clear Block Commands

This table logs recent Clear Block commands issued via calculation scripts, helping audit user actions and block-level data changes.The table includes:

User – The user account that ran the Clear Block operation.
Cube – The name of the cube where blocks were cleared.
Calculation Script – The script used to perform the Clear Block command.
Command – The exact command(s) in the script that led to the block clearing.

Essbase Runtime Metrics

These metrics provide performance insights into recent Essbase operations over the past 24 hours.

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.