Modify and redeploy the model

The model is provided as a JSON file for importing and deploying through the BI Gateway Model Builder web application.

The model uses custom queries for the dimensions. These can be viewed in the JSON file and in the BI Gateway Model Builder. Additional columns can be added to the model by modifying the custom queries.

Note: Any modifications to a query will require a redeployment of the dimension/model, which will delete the existing data and repopulate it from the source system. Therefore, these types of changes should be performed in a smaller test environment due to the impact that the redeployment can have on the MES database.

Whenever the full model or a component of it is redeployed, the existing BI Gateway tables are deleted and the data is repopulated from the source system (that is, the MES database). Therefore, the source data should not be deleted until all model changes have been completed. Also, it is recommended to make a backup of the BI Gateway database before making a model change.

Redeploy the model

1. On the node on which BI Gateway is installed and configured, open the BI Gateway Model Builder.

2. Import the updated MES model file with the default Overwrite option.

3. Validate the data source by connecting to the MES data source.

4. Deploy the model.

   When the new model is deployed, the existing BI Gateway tables are deleted and the BI Gateway database is repopulated with current data from the MES database.