Execute Logging and Statistics

Overview

When a table, dimension, or cube is executed through an execution package, the Jet Data Manager will sign information regarding the event. You have the ability to view the settings used for the execution. The settings are stored in an XML format and displayed as a read-only version of the execution package setup window.

Viewing the Execution Log

1. Right-click the execution package and click View Execution History Log.

   

2. From here you can see various metrics pertaining to the execution package.

   

3. Click View to display the Gantt chart associated with the execution package.  Clicking the View button under the Execution Message column will display the message for that execution.

   The Gantt chart displays an overview of the entire execution process.  In the Gantt chart you can hover your mouse over each individual task to see the details about the object in the tool-tip and if you click an object in the side panel, all other objects will become "grayed" and deselected.

   

   Be aware that execution of tasks in parallel will increase the need for database log file space.  Do not be worried if the size of the log file starts overgrowing the actual data file size.  Do not be tempted for force automatically shrinking of the log file on a regular basis since the file size is actually needed and forcing SQL Server to grow the file on every execution will not be beneficial for project execution performance.

Viewing Execution Log for Individual Objects

1. Click an object in your project and select View Execution Overview Log.

   

2. From here you can see a Gantt chart representing each execution that has taken place.

   

   By default the last 7 executions are selected.  This number can be changed in Tools → General Settings → Execution Log Setting

3. You can select which steps to see in the bar-chart by selecting / deselecting the individual steps in the Execution Steps dialogue:

   

4. You can also select which object to show statistics for in the Objects drop-down.

   

5. In addition, there are a number of ways in which data is captured to provide better analysis over time.  Clicking the Measures dropdown will allow the user to look at a graphical representation of the following:

   

   • Time : The amount of time the object took to run
   • Raw Rows : The total number of rows (records) in the Raw table at the end of the execution process
   • Warnings : The number of warnings present due to validation rules in place
   • Errors : The number of errors present due to validation rules in place
   • Valid Rows : The total number of rows (records) in the Valid table at the end of the execution process