Skip to main content
Pentaho Documentation

Monitor System Performance Using Pentaho Operations Mart

Overview

The Pentaho Operations Mart makes it easy for you to monitor system performance for information, such as how long it takes to run certain reports.

The Pentaho Operations Mart makes it easy for you to monitor system performance for information, such as how long it takes to run certain reports. We automatically set up a way for you to do this using the Operations Mart and Analyzer, Interactive Reports, Report Designer, and Dashboards. The Operation Mart aggregates data from the BA and DI Server log files into pre-built audit reports that provide information you might need. If these reports do not meet your needs, you can use Pentaho Data Integration Operations Mart to change them.

Choose a Pre-Built Operations Mart Report

We provide pre-built Interactive Reports and a data mart called the Pentaho Operations Mart. The Operations Mart contains all the data from system log files. This table shows the reports that we have pre-built for you. Choose the report that fits your needs and follow the instructions in View and Edit Operations Mart Reports.
Table 1. Pre-Built Audit Mart Reports
Information Shown Report Name
Amount of time it takes a report to run Content Duration
File names of all content failures within a defined length of time Content Failures
Compare login metrics for days within a specified month Content Request Day of Month
Compare login metrics for a days in a week within a specified year Day of Week Request and Login Metrics
List of content sorted by type, used within a defined length of time Content Type Usage
List of content usage within a defined length of time Content Usage
Compare login metrics by hour for a specified day Hours in Day Request and Login Metrics
Length of time for logins and the number of logins per user for specified length of time Session Duration Counts

View and Edit Operations Mart Reports

  1. Identify the report that you want to open from Choose a Pre-Built Operations Mart Report.
  2. Double-click Browse Files.
  3. Click on public > Pentaho Operations Mart > BA Audit Reports.
  4. Select the appropriate file and click Open. Your monitoring and logging data appears in the pre-built report.
  5. If you need to edit this report, you can do so from within the opening tool.

See Build Web-Based Data Analysis, Reports, and Dashboards for more information about editing a report in Analyzer or Interactive Reporting.

See Design Print-Quality Reports for more information about editing a report using Report Designer.

Create Operations Mart Reports

If the reports we provide are not quite right for you, you can create your own reports.

  1. From within the User Console, select Create New and then choose the type or report you want to create.
  2. Select the data source that you need.
    Information Shown Data Source
    Detail information related to the execution of the.xactions. that run the reports on the BA Server pentaho_operations_mart: BA Operations Mart - Component
    Information related to the execution of content , such as which tool or which user ran the content on the BA Server pentaho_operations_mart: BA Operations Mart - Content
    Information for the BA Server related to a user, such as number of sessions, how long, and what time pentaho_operations_mart: BA Operations Mart - User Session
    Information about individual job entry executions on the DI Server pentaho_operations_mart: PDI Operations Mart - Job Entry
    Detailed performance information for the DI Server pentaho_operations_mart: PDI Operations Mart - Performance
    Detailed information about individual step executions on the DI Server pentaho_operations_mart: PDI Operations Mart - Step
    Information related to transformations and jobs run on the DI Server pentaho_operations_mart: PDI_Operations_Mart
  3. Create a new report as described in the appropriate user section.

See Build Web-Based Data Analysis, Reports, and Dashboards for more information about building a report in Analyzer or Interactive Reporting.

See Design Print-Quality Reports to build a report using Report Designer.

Update the Operations Mart

You may need to update the report date and time, or the data that is populated into the report itself.

  1. From within the User Console, select Browse Files > public > Pentaho Operations Mart > Update Audit Mart.
  2. Double-click either Update Operations Mart Date & Time or Update BA Operations Mart Data.
  3. View a report to confirm that the updates applied.