Overview

The Operational Reporting feature solves the business requirement of generating reports from the operational data.

Operational reports are generated by joining different tables that generate a view.

The available reports are:

Base Views vs Reporting Views

A base view is generated one-to-one with the OHI tables after joining with translation tables, while reporting views are built keeping business needs in mind by combining multiple tables.

For more information, see Concepts.

Reporting views are predefined.

Generating Views

Generating Base Views

The application displays the data model as base views. A base view gives an idea of the technical table structure with several benefits:

  • A base view combines fields from base and translation tables.

  • A base view includes fixed and dynamic fields.

  • Extensibility structures like dynamic field and dynamic record definition have additional views.

For more information on how to generate a base view, see Base View Generation.

Generating Reporting Views

A reporting view is a system seeded view with predefined columns.

  • A reporting view joins multiple tables.

  • To incorporate dynamic fields related to the base entity of a specific view, generating the reporting view is necessary, as it automatically includes single value dynamic fields.

For more information on how to generate a reporting view, see Generating Reporting Views.

Access Grants

In order to effectively utilize all aspects of the Operational Reporting and Data Transfer capabilities, you need necessary permissions for both API and JET user interface.

For information on the required access grants, see User Access.

Schema Design

For information on the schema design for Operational Reporting, and the schema used by the Data Transfer integration point and Operational Reporting user interface pages, see Concepts.

Metrics

The following two metrics are specific to Operational Reporting. They inform us how many rows have been fetched for a single view.

  • ohi.reporting.fetched.rows.count.per.view - Number of rows fetched per view.

  • ohi.views.metrics - Time taken to run the query.

For more information on the above metrics, see the Operational Reporting Metrics section in Gathering Metrics.