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 TRIRIGA Workplace Performance Management and TRIRIGA 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.