Try Pentaho Data Integration and Analytics

Business Analytics Operations Mart

Pentaho automatically sets up a way for using the Operations Mart and Analyzer, Interactive Reports, Report Designer, and Dashboards. The Business Analytics (BA) Operations Mart aggregates data from the Pentaho 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 Data Integration Operations Mart to change them.

Download and install Operations Mart files

Operation Mart files are stored in a pre-packaged ZIP file. To install the files, you must stop the Pentaho Server, download and unpack the ZIP file, run a script to accept the EULA and place the files in the correct directory, and then restart the Pentaho Server to import the files.

  1. Stop the Pentaho Server.

    Note: See the Install Pentaho Data Integration and Analytics document for instructions on stopping and starting the Pentaho Server.

  2. Download the pentaho-operations-mart-9.3.0.0-<build number>-dist.zip file from the Support Portal.

    1. On the Support Portal home page, sign in using the Pentaho support username and password provided in your Pentaho Welcome Packet.

    2. In the Pentaho card, click Download.

      The Downloads page opens.

    3. In the 9.x list, click See all <number> articles to see the full list of 9.x downloads.

    4. On the 9.x page, click Pentaho 9.3 GA Release.

    5. Scroll to the bottom of the Pentaho 9.3 GA Release page.

    6. In the file component section, navigate to the Operations Mart folder.

    7. Download the pentaho-operations-mart-9.3.0.0-<build number>-dist.zip file.

  3. Unpack the pentaho-operations-mart-9.3.0.0-<build number>-dist.zip file in a temporary directory.

    The pentaho-operations-mart-9.3.0.0-<build number> directory is created in the temporary directory.

  4. In the pentaho-operations-mart-9.3.0.0-<build number> directory, run one of the following scripts that is appropriate for the OS:

    • install.bat

    • install.sh

    • installer.jar

  5. In the IZPack window read the license agreement, select I accept the terms of this license agreement, then click Next.

  6. In the Select the installation path text box, save the file in the pentaho/server/pentaho-server/pentaho-solutions/system/default-content directory, then click Next.

  7. A warning message appears. Click Yes.

  8. When the installation finishes, click Quit.

  9. Navigate to the pentaho/server/pentaho-server/pentaho-solutions/system/default-content directory, and then delete any files that you don't need for your repository's platform.

    The following table lists the files to keep for each type of Pentaho Repository database.

Repository database type

Files to keep

PostgresSQL

  • pentaho-operations-mart-clean-9.3.0.0-<build number>.zip *

  • pentaho-operations-mart-etl-9.3.0.0-<build number>.zip

  • ​pentaho-operations-mart-operations-bi-9.3.0.0-<build number>.zip

MySQL

  • pentaho-operations-mart-clean-mysql5-9.3.0.0-<build number>.zip *

  • pentaho-operations-mart-etl-mysql5-9.3.0.0-<build number>.zip

  • ​pentaho-operations-mart-operations-bi-9.3.0.0-<build number>.zip

Oracle

  • pentaho-operations-mart-clean-oracle10g-9.3.0.0-<build number>.zip*

  • pentaho-operations-mart-etl-oracle10g-9.3.0.0-<build number>.zip

  • ​pentaho-operations-mart-operations-bi-9.3.0.0-<build number>.zip

MS SQL Server

  • pentaho-operations-mart-clean-mssql-9.3.0.0-<build number>.zip *

  • pentaho-operations-mart-etl-mssql-9.3.0.0-<build number>.zip

  • ​pentaho-operations-mart-operations-bi-9.3.0.0-<build number>.zip

* Keep the pentaho-operations-mart-clean-<database>-9.3.0.0-<build number>.zip file only if you plan for Pentaho to automatically delete entries from the operations mart on a regular schedule. For more information, see Clean up Operations Mart.

10. Restart the Pentaho Server.

  1. If you have deployed Pentaho on JBoss and use any supported database (MySQL, MS SQL Server, Oracle, PostgreSQL), update the JNDI name in the pentaho_operations_mart connection after the server has started.

    1. In PUC, click Manage Data Sources.

    2. In the Manage Data Sources window, select PDI_Operations_Mart.

    3. Click the settings cog, and then click Edit.

      The Database Connection window opens.

    4. In the JNDI Name box, enter jboss/datasource/PDI_Operations_Mart.

    5. Click OK.

The Operations Mart is ready to be used.

Increase the maximum character length in audit table fields You can increase the maximum number of characters permitted in an audit table field from 200 to 1024 characters.

Note: The scripts in the following procedure adjust the column width and re-index the Operations Mart tables.

Complete the following steps to increase the maximum number of characters:

  1. Stop the Pentaho Server.

    Note: See the Install Pentaho Data Integration and Analytics document for instructions on stopping and starting the Pentaho Server.

  2. Download the pentaho-server-ee-9.3.0.0-<build number>-dist.zip file from the Support Portal.

    1. On the Support Portal home page, sign in using the Pentaho support username and password provided in your Pentaho Welcome Packet.

    2. In the Pentaho card, click Download.

      The Downloads page opens.

    3. In the 9.x list, click See all <number> articles to see the full list of 9.x downloads.

    4. On the 9.x page, click Pentaho 9.3 GA Release.

    5. Scroll to the bottom of the Pentaho 9.3 GA Release page.

    6. In the file component section, navigate to the Pentaho Server/Archive Build (Suggested Installation Method) folder.

    7. Download the pentaho-server-ee-9.3.0.0-<build number>-dist.zip file.

  3. Unpack the pentaho-server-ee-9.3.0.0-<build number>-dist.zip file into a temporary directory.

    The pentaho-server-ee-9.3.0.0-<build number> directory is created in the temporary directory.

  4. In the pentaho-operations-mart-9.3.0.0-<build number> directory, run one of the following scripts that is appropriate for the OS:

    • install.bat

    • install.sh

    • installer.jar

  5. In the IZPack window read the license agreement, select I accept the terms of this license agreement, then click Next.

  6. In the Select the installation path text box, save the file in a temporary directory, and then click Next.

  7. A warning message appears. Click Yes.

    The installation begins.

  8. When the installation finishes, click Quit.

  9. Navigate to the temporary directory where you unpacked the files and locate the following files for your repository type:

    • alter_script_< your repo type >_BISERVER-13674.sql

    • pentaho_mart_upgrade_audit_<your repo type>.sql

  10. Using the SQL client tool for your repository type, run the following scripts, in order:

    1. alter_script_< your repo type >_BISERVER-13674.sql

    2. pentaho_mart_upgrade_audit_<your repo type>.sql

    The scripts are executed.

  11. Delete to the temporary directory you created previously.

  12. Start the Pentaho Server.

The maximum field length for audit tables is now 1024 characters.

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.

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

Perform the following steps to 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 the Pentaho Business Analytics document for more information about editing a report in Analyzer or Interactive Reports.

See the Pentaho Report Designer document for more information about editing a report using the designer.

See Data Integration Operations Mart for more information.

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 Pentaho 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 Pentaho Server

    pentaho_operations_mart: BA Operations Mart - Content

    Information for the Pentaho 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 Pentaho Server

    pentaho_operations_mart: PDI Operations Mart - Job Entry

    Detailed performance information for the Pentaho Server

    pentaho_operations_mart: - PDI Operations Mart - Performance

    Detailed information about individual step executions on the Pentaho Server

    pentaho_operations_mart: PDI Operations Mart - Step

    Information related to transformations and jobs run on the Pentaho Server

    pentaho_operations_mart: PDI_Operations_Mart

  3. Create a new report as described in the appropriate user section.

See the Pentaho Business Analytics document for more information about editing a report in Analyzer or Interactive Reports.

See the Pentaho Report Designer document for more information about editing a report using the 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.

Clean up Operations Mart

The operational data in Operations Mart tables are set to automatically remove entries older than 365 days. If you want to change this schedule so that the operational data is deleted using a different time frame, you will need to add a variable, named ba.cleanup.max.age, in the kettle.properties file located in the {user.home}/.kettle directory.

  1. Stop the Pentaho Server.

  2. Open the kettle.properties file located in the administrative user's {user.home}/.kettle directory.

  3. Add the ba.cleanup.max.age variable to indicate the age above which entries are deleted.

    If you want to delete entries that are older than 30 days, add this:

    ba.cleanup.max.age=30

  4. Save and close the kettle.properties file.

  5. Restart your Pentaho Server for the setting to take effect.

PreviousPentaho Operations MartNextData Integration Operations Mart

Last updated

Was this helpful?