Generating a Calculation Statistics Diagnostics Report

The Calculation Statistics Diagnostics report shows you diagnostics information for up to five calculation records. The report shows additional rule execution detail which can be useful in diagnosing rule performance issues.

The report prints in an Excel format and has two worksheets:

To generate a Calculation Statistics Diagnostics report:

  1. From the Home page, select Modeling, and then Calculation Analysis.

  2. From the Calculation Analysis page, select up to five calculation records.

  3. Click the Actions drop-down, and select Calculation Statistics Reports, and then select Diagnostics.

  4. Open the downloaded EngineStatisticsComparisonReport.xlsx file.

Job Statistics

Job Statistics shows the calculation record-level statistics and provides a comparison on some of those statistics. Job Statistics include information such as:

  • Job Order

  • Job ID

  • Job Start Time

  • Job End Time

  • Job Total Time (min)

  • Job Total Time Percent

  • POV Name

  • Model Name

  • Model Snapshot Time

  • Job Status

  • EPM Build Number

  • Essbase Build Number

  • Calculation Threads

  • Essbase Clear Type

  • Non Empty Tuple

  • Clear Calculation Data Time (min)

  • Clear Aggregations Time (min)

  • Rules Total Time (min)

  • Clear Scratch Cells Time (min)

  • Merge Slices Time (min)

  • Create Aggeregations Time (min)

  • Generation Time (min)

  • Execution Time (min)

  • Allocation Time (min)

  • Custom Calc Time (min)

  • Driver Query Time (min)

  • Clear Partial Time (min)

  • Cells Updated

  • Cells Updated Percent

  • Number of Rules

  • Rules Complete

  • Sub Rules

  • Sub Rules Complete

  • SDE Rules

  • CDE Rules

  • SR Rules

  • CR Rules

  • CC Rules

  • SASDD Rules

  • Number of Scripts

  • Scripts Complete

  • Allocation Scripts

  • Custom Calc Scripts

  • Driver Queries

  • Clear Partial Scripts

  • Attribute Dimensions

  • Attribute Dimension Members

  • Attribute Associations

  • Dimensions

  • Dimension Members

  • Dimension Members Cross Product

  • Dimension Members Cross Product Percent

  • Essbase Sessions Pre

  • Essbase Sessions Post

  • Input Cells Start

  • Input Cells Start Percent

  • Incremental Input Cells Start

  • Aggregate Cells Start

  • Input Cells End

  • Input Cells End Percent

  • Incremental Input Cells End

  • Aggregate Cells End

Sample Job Statistics

Job Statistics tab with some sample job statistics

Tip:

Use the scroll bar at the bottom of the Excel spreadhsheet to see additional Job Statistics.

Rule Statistics

Rule Statistics shows all the rules that were executed and the order in which they were executed along with statistical data about each rule. Rule Statistics include information such as:

  • Rule Order

  • Job ID

  • POV Name

  • Model Name

  • Start Time

  • End Time

  • Rule Set Name

  • Rule Name

  • Total Time (min)

  • Total Time Percent

  • Generation Time (min)

  • Generation Time Percent

  • Execution Time (min)

  • Execution Time Percent

  • Execution Time - Allocation Calc (min)

  • Execution Time - Custom Calc (min)

  • Execution Time - Driver Query (min)

  • Execution Time - Clear Partial (min)

  • Cells Updated

  • Cells Updated Percent

  • Potential Sources

  • Potential Sources Percent

  • Potential Destinations

  • Potential Destinations Percent

  • Potential Allocations

  • Potential Allocations Percent

  • Number of Scripts

  • Scripts Complete

  • Allocation Scripts

  • Custom Calc Scripts

  • Driver Queries

  • Clear Partial Scripts

  • Sub Rules

  • Sub Rules Complete

Sample Rule Statistics

Rules Statistics tab with some sample rules statistics

Tip:

Use the scroll bar at the bottom of the Excel spreadhsheet to see additional Rule Statistics.