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 BA Operations Mart files
Procedure
Stop the Pentaho Server.
Download the pentaho-operations-mart-9.0.0-dist.zip file from the Pentaho Customer Support Portal.
On the Customer Portal home page, sign in using the Pentaho support user name and password provided in your Pentaho Welcome Packet.
Click Downloads, then click Pentaho 9.0 GA Release in the 9.x list.
On the bottom of the Pentaho 9.0 GA Release page, click the Operations Mart folder in the Box widget and download the pentaho-operations-mart-9.0.0-dist.zip file.
Unpack the file by running install.sh or install.bat.
In the IZPack window read the license agreement, select I accept the terms of this license agreement, then click Next.
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.
A warning message appears. Click Yes.
When the installation finishes, click Quit.
Go to the pentaho/server/pentaho-server/pentaho-solutions/system/default-content directory, then delete any files that you don't need for your repository's platform.
If your Pentaho Repository is On: Only Keep These Files PostgresSQL - pentaho-operations-mart-clean-9.0.0.zip *
- pentaho-operations-mart-etl-9.0.0.zip
- pentaho-operations-mart-operations-bi-9.0.0.zip
MySQL - pentaho-operations-mart-clean-mysql5-9.0.0.zip *
- pentaho-operations-mart-etl-mysql5-9.0.0.zip
- pentaho-operations-mart-operations-bi-9.0.0.zip
Oracle - pentaho-operations-mart-clean-oracle10g-9.0.0.zip*
- pentaho-operations-mart-etl-oracle10g-9.0.0.zip
- pentaho-operations-mart-operations-bi-9.0.0.zip
MS SQL Server - pentaho-operations-mart-clean-mssql-9.0.0.zip *
- pentaho-operations-mart-etl-mssql-9.0.0.zip
- pentaho-operations-mart-operations-bi-9.0.0.zip
* Keep the pentaho-operations-mart-clean-<database>-9.0.0.zip file only if you want Pentaho to automatically delete entries from the operations mart on a regular schedule. For more information, see Clean up Operations Mart. Restart the Pentaho Server.
If you've deployed Pentaho on JBoss, after the server is started, update the JNDI name in the pentaho_operations_mart connection PDI_Operations_Mart to jboss/datasource/PDI_Operations_Mart.
The Operations Mart tables and schemas are on the Pentaho Repository. If you’ve deployed the Pentaho Repository on MySQL, MS SQL Server, or Oracle, you'll need to update the pentaho_operations_mart data database connection information.
Click the Manage Data Sources button in PUC and select pentaho_operations_mart.
Change the database connection information so that it reflects the information needed to connect to your Pentaho Repository.
Results
Increase the maximum character length in audit table fields
Follow the instructions below to increase the maximum character count:
Procedure
Stop the Pentaho Server.
Download the pentaho-server-ee-8.3.x.yy-dist.zip file from the Customer Portal.
On the Customer Portal home page, sign in using the Pentaho support user name and password provided in your Pentaho Welcome Packet.
Click Downloads, then click Pentaho 8.3 GA Release in the 8.x list.
Near the bottom of the Pentaho 8.3 GA Release page, click the Pentaho Server folder in the Box widget and download the pentaho-server-ee-8.3.x.yy-dist.zip file.
Extract the file.
Unpack the file by running install.sh or install.bat.
In the IZPack window read the license agreement, and accept the terms of the agreement, then click Next.
In the Select the installation path text box, save the file in a temporary directory, then click Next.
A warning message appears. Click Yes.
The installation begins.When the installation finishes, click Quit.
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
Using the SQL client tool for your repository type, run these scripts in this order:
alter_script_< your repo type >_BISERVER-13674.sql
pentaho_mart_upgrade_audit_<your repo type>.sql
Delete to the temporary directory you created above.
Start the Pentaho Server.
Results
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
Procedure
Identify the report that you want to open from Choose a Pre-Built Operations Mart Report.
Double-click Browse Files.
Click on:
Select the appropriate file and click Open. Your monitoring and logging data appears in the pre-built report.
If you need to edit this report, you can do so from within the opening tool.
Next steps
See Pentaho Report Designer for more information about editing a report using the designer.
See Data Integration Operations Mart for more information.
Create Operations Mart reports
Procedure
From within the User Console, select Create New and then choose the type or report you want to create.
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 Create a new report as described in the appropriate user section.
Next steps
See Pentaho Report Designer for more information about editing a report using the designer.
Update the Operations Mart
Procedure
From within the User Console, select:
Double-click either: Update Operations Mart Date & Time or Update BA Operations Mart Data
View a report to confirm that the updates applied.
Clean up Operations Mart
Procedure
Stop the Pentaho Server.
Open the kettle.properties file located in the administrative user's {user.home}/.kettle directory.
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
Save and close the kettle.properties file.
Restart your Pentaho Server for the setting to take effect.