Fact tables

Fact tables consist of the measurements, metrics, or facts of a business process. Fact tables store the data that is used to calculate the metrics in metric reports.

Fact table information is based on the as-delivered IBM® Maximo® Real Estate and Facilities Workplace Performance Management and IBM Maximo Real Estate and Facilities Real Estate Environmental Sustainability products. The implementation at your company might be different.

Each fact table has an ETL to load data and another to clear data. The names of the ETLs that clear data end with – Clear, for example Building Cost Fact – Clear. To view the ETLs, click Tools > System Setup > ETL Job Items.