Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

TABLE OF CONTENTS

Configure and deploy MES BI Gateway reports

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedMay 02, 2025
  • 2 minute read

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 Performance, Operations, and Quality data tables.

This section describes how to configure and deploy the MES BI Gateway reports. There are multiple steps involving software components other than MES [that is, BI Gateway and SQL Server Reporting Services (SSRS)].

The MES installation software no longer includes the BI Gateway software. BI Gateway must be downloaded separately from the AVEVA support site. No licensing is required to use BI Gateway solely for MES Reporting.

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.

Prerequisites

Prior to configuring and deploying MES BI Gateway reports, note the following prerequisites:

  • For BI Gateway, MES only supports the use of a local SQL Server and not Azure SQL.

  • Prior to configuring and deploying the MES BI Gateway reports, verify that the SSRS Report Server has been configured using the Report Server Configuration Manager. This configuration creates the Report Server database and the Report Server Web Service and Web Portal URLs. Also verify that the SSRS service is running.

  • 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 SSRS.

Upgrading the MES BI Gateway Model

  • The MES 2023 R2 BI Gateway Model is the same as the MES 2017 R2 and MES 2020 Intelligence Model. If you upgraded from MES 2017 R2, MES 2020, or MES 2023 to MES 2023 R2, there is no need to upgrade the MES Intelligence Model.

  • If you are upgrading from MES 2014 R3 (version 5.3) or MES 2017 (version 6.0), and Intelligence 2014 R3 (version 2.1), perform the procedure in Upgrade to the MES 2020 Intelligence model.

In This Topic
TitleResults for “How to create a CRG?”Also Available in