Skip to main content
Version: 24.3

Fact Tables

This topic explains how to use the fact tables in Agility.

In a star schema fact tables contain the measurement data being used in reports. This data can be analyzed or classified by information available in dimension tables. In the Digital.ai Agility datamart, all Fact tables are in a database namespace (schema) known as "Fact". The following tables are the primary fact tables available in the Agility datamart schema.

Other Fact tables​

As part of the ETL process several other Fact tables are generated. The data in these tables is then merged into the Workitem Fact table. If you want to generate a report that only deals with a specific data type, and you do not want to filter the Workitem facts, you may opt for using one of these alternate tables.

  • PrimaryWorkitem
  • Task
  • Test
Tags:
Last updated on