How to connect to Data Mart

The structure of the Dispatcher Paragon Data Mart Mode feature makes importing data from Data Mart mostly automatic.

Enable Enterprise Reporting

This is a few step recapitulation of more detail explanation from Data Mart Mode article.

Requirements

  • Reporting License - Data Mart Mode functionality requires the Dispatcher Paragon Reporting module license included in the environment.

How to enable

  1. In Dispatcher Paragon management interface, log as a user with admin access.

  2. Navigate to System Settings tab.

  3. Set configuration property enableCMLDataMart to Enabled.
    Note: This setting is turned off by default with all Dispatcher Paragon installations.

Other considerations, best practices

  • When Data Mart is enabled, it is recommended to disable the Web Reports functionality for performance reasons. Set web-stats-enable to Disabled.

  • When Data Mart is enabled, it is recommended to disable the Management Reports functionality for performance reasons. Set enableManagementReport to Disabled .

  • Use the following properties to fine-tune statistics data retention:

    • maxStatsMonthsBase - Maximum number of months, for which web reports and counter reports data are stored. Default value is 36.

    • maximumCMLDataMartMonths - Maximum number of months, for with the data mart measurements are kept. Default value is 36.

    • maxStatsDaysFull - Maximum number of days, for which unaggregated web reports are kept. Default value is 31. It is NOT recommended to adjust the number without consulting Konica Minolta.

    • remove-jobs-from-db - Maximum number of days, after which the print jobs metadata will be removed (along with jobs log and jobs accounting metadata). Default value is 31. It is NOT recommended to adjust the number without consulting Konica Minolta.

    • printJobAgeForStats - M inimum age of print jobs to include in web reports and data mart statistics for Management Service cluster environment, in minutes. Allowed range is between 20 and 120. It is NOT recommended to adjust the number without consulting Konica Minolta.

    • enable-purge_reports - Either enables or disables Green Reports found on the Administrator or End-User Dashboards. This value should be enabled in order to capture, and report on, savings.

Connect Business Intelligence tool to Data Mart

Use Business Intelligence tool for connection with data mart and create your own customised reports.