> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pdia-admin/9.3-administer/optimize-the-pentaho-system/monitoring-system-performance/pentaho-operations-mart/business-analytics-operations-mart.md). # 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](/pdia-admin/9.3-administer/optimize-the-pentaho-system/monitoring-system-performance/pentaho-operations-mart/data-integration-operations-mart.md) 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--dist.zip` file from the [Support Portal](https://support.pentaho.com/hc/en-us). 1. On the [Support Portal](https://support.pentaho.com/hc/en-us) 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 \ 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--dist.zip` file. 3. Unpack the `pentaho-operations-mart-9.3.0.0--dist.zip` file in a temporary directory. The `pentaho-operations-mart-9.3.0.0-` directory is created in the temporary directory. 4. In the `pentaho-operations-mart-9.3.0.0-` 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-\.zip \*
  • pentaho-operations-mart-etl-9.3.0.0-\.zip
  • ​pentaho-operations-mart-operations-bi-9.3.0.0-\.zip
| | MySQL |
  • pentaho-operations-mart-clean-mysql5-9.3.0.0-\.zip \*
  • pentaho-operations-mart-etl-mysql5-9.3.0.0-\.zip
  • ​pentaho-operations-mart-operations-bi-9.3.0.0-\.zip
| | Oracle |
  • pentaho-operations-mart-clean-oracle10g-9.3.0.0-\.zip\*
  • pentaho-operations-mart-etl-oracle10g-9.3.0.0-\.zip
  • ​pentaho-operations-mart-operations-bi-9.3.0.0-\.zip
| | MS SQL Server |
  • pentaho-operations-mart-clean-mssql-9.3.0.0-\.zip \*
  • pentaho-operations-mart-etl-mssql-9.3.0.0-\.zip
  • ​pentaho-operations-mart-operations-bi-9.3.0.0-\.zip
| | \* Keep the `pentaho-operations-mart-clean--9.3.0.0-.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](broken://pages/E7SksHL6qxUXbIVyxc7u). | | 10\. Restart the Pentaho Server. 11. 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--dist.zip` file from the [Support Portal](https://support.pentaho.com/home). 1. On the [Support Portal](https://support.pentaho.com/hc/en-us) 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 \ 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--dist.zip` file. 3. Unpack the `pentaho-server-ee-9.3.0.0--dist.zip` file into a temporary directory. The `pentaho-server-ee-9.3.0.0-` directory is created in the temporary directory. 4. In the `pentaho-operations-mart-9.3.0.0-` 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_.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_.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](broken://pages/Dh2BCtf1EOwuvHmPrA23). | 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](/pdia-admin/9.3-administer/optimize-the-pentaho-system/monitoring-system-performance/pentaho-operations-mart/data-integration-operations-mart.md) 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. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.pentaho.com/pdia-admin/9.3-administer/optimize-the-pentaho-system/monitoring-system-performance/pentaho-operations-mart/business-analytics-operations-mart.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.