Deploy the SSRS MES reports against the BI Gateway database

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).

1. In the Windows Services tool on the node on which SSRS and BI Gateway is installed, make sure the SSRS service is running.

2. Open Configurator and select the MES BI Gateway Reports component.

   

   A message in the Configuration Messages box prompts you to install the BI Gateway hotfix.

3. Install BI Gateway hotfix HF_2172196, which can be found in the BI Gateway Reports folder within the MES application folder. This is a cumulative hotfix that also includes BI Gateway HF_1848891. Refer to the instructions in the hotfix Readme file.

4. In Configurator, change the MES BI Gateway Reports configuration settings from the default entries as needed.

   BI Gateway Database Node

   • Server Name: The server name on which the BI Gateway database is stored. This can be localhost or the local node's host name.

   • Database Name: The name of the BI Gateway database.

     Note: If BI Gateway was upgraded from a previous version of Intelligence, make sure that the database name entered here matches the existing Intelligence database name (and not the BI Gateway default name BIGateway_DataStore). Also, the name of the existing Intelligence database cannot be changed.

   • User account information: The user account for accessing the BI Gateway database. See Specify SQL Server user authentication. The user account specified here requires read access to the BI Gateway database.

     Note: AVEVA recommends using Windows integrated security rather than SQL Server authentication to access SQL Server because it is more secure.

     SQL Server Reporting Services Node

   • Target Report Server: The name of the report server on which SSRS is running. This can be localhost or the local node's host name.

   • Virtual Folder: The name of the report server's virtual folder.

   • Target Report Folder: The name of the target report folder that will be created by the configuration operation for the MES reports.

   • User account information: The user account for accessing the report server on which to deploy the MES reports. See Specify SQL Server user authentication.

5. Click Configure.

   The data source to connect to the BI Gateway database, the MES reports folder, and the MES BI Gateway reports are created on the SSRS server.

6. From the Reporting Services Configuration Manager application, verify that the MES Reports have been deployed and that their links are accessible from the MES Reports - Report Manager web page.

   

7. Verify that the following views, stored procedures, and functions were created in the BI Gateway database.

Loading of MES Data into the BI Gateway Database

Once all the configuration steps have been completed, the BI Gateway services extract data from the MES database, transform it, and populate the newly created tables in the BI Gateway database.

The initial loading of the BI Gateway database might take some time, depending on either:

• The Override Data Backfill date entered in the Import Model dialog of the BI Gateway Model Builder when importing the model

• The Data Collection Start date entered in the BI Gateway Model Builder

While the backfill process continues, the BI Gateway service will start collecting current data for the reports. Wait at least an hour after deployment for the MES data to be loaded into the BI Gateway database before attempting to run any MES BI Gateway reports.

Some of the reports will not show data until the second run of the BI Gateway service to update the dimensional data. Unless specifically changed by an end user, this can take up to an hour.

If there is no MES data in the BI Gateway database, then verify that the BI Gateway services are running. Also check the System Management Console error log of BI Gateway.