Configure and deploy MES BI Gateway reports

The MES reporting content defaults to using the BI Gateway database as the source for the report data. The BI Gateway model includes content from MES Performance, Operations, and Quality data tables.

The section in the MES Installation Guide called "Configuring and Deploying MES BI Gateway Reports" describes how to configure and deploy the MES BI Gateway reports.

The MES installation software includes a non-licensed limited version of BI Gateway that can be used solely with MES BI Gateway reports. The MES BI Gateway reports will also work with a full version of BI Gateway.

Note: To install the Quality Characteristic Detail report's SPC Chart control, the MES BI Gateway Reports component must be installed and configured on the same node as the BI Gateway Datastore and SQL Server Reporting Services (SSRS).

The configuration and deployment of the MES BI Gateway reports includes the following procedures:

1. If not already performed, configuring the BI Gateway components and MES Database Setup component.

2. Importing and deploying the MES BI Gateway model.

3. Deploying the SSRS MES reports against the BI Gateway database.

4. Configuring the security policies for the Quality Characteristic Detail report.

Once deployed, links to the MES BI Gateway Reports are included in a folder within the standard SSRS Report Manager web page. The default folder is MES Reports, but that can be modified during the MES BI Gateway Reports configuration.

The default SSRS Report Manager web page for the MES reports is shown below, but access to the reports can be implemented in many ways.

Note the following about the configuration and deployment:

• The MES Quality Characteristic Detail report includes a subreport containing a .NET control for displaying the SPC Chart. This report requires that certain security policy settings for Reporting Services are configured to display the .NET control.

  To configure these security policy settings, follow the instructions provided in the Reporting Services Security Configuration.txt file that is located in the BI Gateway Reports\Reports folder of the MES application folder.

• By default, dimensions and dependencies will be updated at 25 minutes past the hour.

• If there is a large amount of data in the MES database loaded into the BI Gateway database, then it is recommended to periodically remove duplicate records to improve data retrieval performance. The BI Gateway tables with the largest amount of data are generally the following three. Execute these statements against the BI Gateway database to delete their duplicate records.

  Delete from MESRDBUtilization where aaObsolete = 1

  Delete from MESRDBItemProduction where aaObsolete = 1

  Delete from MESRDBItemConsumption where aaObsolete = 1

• The BI Gateway database and the MES database are expected to be in the same time zone. This is so that local times for measures that are calculated by the BI Gateway server will match local times from dimensions that are copied from the source (that is, the MES database).