MESRDBHourlyUtilization Measure Table Has Historical Data But Not All of It

When initially deploying the BI Gateway model for MES against a database with large amounts of existing data, the backfill process for the Hourly Utilization measure takes longer than all the other dimensions and measures.

Once all the dimensions and other measures are backfilled, the process for the Hourly Utilization measure will likely still be happening. As long as there are messages indicating that the processing is continuing, then BI Gateway is still working on it.

In very large systems with millions of records, the service has been observed to take 3 to 4 minutes to process each hourly bucket. For such a system, it may take days or weeks to complete the backfill process per year of data.