MES BI Gateway reports dimensional model

The MES BI Gateway reports use the BI Gateway database for their data instead of the MES database. This is done to limit the performance impact that a large report query would cause on the MES database server.

To optimize performance, the MES database should be on a separate server from the BI Gateway database.

BI Gateway is used as the mechanism to periodically extract data out of the MES database, transform it to a star schema, and store it in the BI Gateway database for easier reporting. Since the data is not residing in the MES database and the extraction occurs periodically, the report developer should understand the following about the BI Gateway model that is used by the MES product:

• The underlying dimension and measure model

• The settings used in the model

• The additional views and stored procedures that query the dimension and measure tables

• The links between all the components.