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

Import and deploy the MES BI Gateway model

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedOct 18, 2024
  • 3 minute read

The MES BI Gateway model includes content from Performance, Operations, and Quality data tables.

  1. When the computer has rebooted after completing the configuration tasks, open the BI Gateway Model Builder in a web browser by entering the URL https://localhost:61075.

    Note: The BI Gateway Model Builder supports only Chrome web browser.

    BI Gateway Model Builder welcome screen showing a navigation menu and a primary panel describing how to import an existing model and add new objects.

  2. On the main menu, click Import.

    The Import Model screen appears.

  3. Click the Choose a File button, then navigate to and select the MESIntelligenceModel.json file.

    The file is stored in the BI Gateway Reports folder within the MES application folder.

    BI Gateway Model Builder import model dialog with MES Intelligence Model JSON selected for import

  4. Select the Overwrite option.

    If the Overwrite option is not selected, duplicated MES objects will be created.

  5. Optionally, enter a date for the Override Data Backfill.

    If no value is provided here, then the Backfill dates defined in the JSON model file for each dimension will apply.

  6. Click Import.

  7. When the import is completed, click Done.

    The measures, dimensions, and data source appear. They are tagged in yellow, indicating that they are not deployed.

    BI Gateway Model Builder screen showing the imported preconfigured MES Intelligence Model measures, dimensions, and data source objects.

  8. To configure the MES BI Gateway Reports data source, select the MESRDBMESDB data source object.

  9. In the General tab in the right panel:

    • In the Data Source time zone field, select (UTC) Coordinated Universal Time.

    • In the Server name field, enter the host name of the node where the MES database is stored.

    • In the Database name field, enter the MES database name.

      BI Gateway Model Builder screen showing the MES intelligence model data source object general tab with the data source time zone, server name, and database name properties highlighted.

  10. Click Connect.

    You are prompted whether you want to continue to connect to the data source and get the schema.

    BI Gateway Model Builder dialog confirming connection to the MES data source.

  11. Click Continue.

  12. When the schema has been retrieved, click Done.

    BI Gateway Model Builder dialog confirming MES data source schema retrieval.

  13. In the Windows Services tool on the node on which BI Gateway is installed, make sure the Intelligence Service is running.

  14. On the main menu, click Deploy All.

    You are prompted whether you want to deploy all objects.

    BI Gateway Model Builder dialog confirming MES data source schema deployment and specifying to keep existing data.

  15. Click Keep Data.

  16. When the objects have been deployed, click Done.

    The measures, dimensions, and data source are tagged in green, indicating that they are deployed.

    BI Gateway Model Builder screen showing the deployed MES intelligence model measures, dimensions, and data source objects.

  17. You can close BI Gateway Model Builder.

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