Facts that require special staging tables and ETLs

For most fact tables, the process to load the stored data to calculate metrics is simple. However, some fact tables require special staging tables, and ETLs to assist with the loading process.

The following table shows the facts that require special staging tables and ETLs:
Table 1. Facts that require special staging tables and ETLs
Fact table name Fact table business object
Financial Summary triFinancialSummary
Standard Hours triStandardHours
Standard Hours Details triStandardHoursDetails
Asset Analytic Hourly Fact triAssetAnalyticHFact
Asset Energy Use Daily Fact triAssetEnergyUseDFact
Asset Energy Use Hourly Fact triAssetEnergyUseHFact
Asset Energy Use Monthly Fact triAssetEnergyUseMFact