Verifying the data in the fact table

Use the following steps to locate errors in the fact table data.

Procedure

  1. To verify that the hourly fact table records have data points that match the rule conditions and periods, build a query that displays the data points that are related to this rule for the periods and the asset or node in question.
    The data point should match the Period End of the Asset Analytic Process.
  2. Verify that the hourly fact table does not have corrupted reference Ids by checking the Workflow View Error.
  3. Verify that the devices in the hourly fact table have unique assets.
    The analytic process will not retrieve data for an asset that is assigned to more then one device.