Skip to main content
System StatusContact Support

Documentation related to the following products will soon be moved to a new portal: ( Agility, Agility Connect and Agility Integrations Continuum and ALM Connect
Links from the site will automatically redirect to the new site.
If you have any questions, please contact Support. Agility Community

Fact Tables

This feature is available in Enterprise and Ultimate editions.

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 VersionOne datamart, all Fact tables are in a database namespace (schema) known as "Fact". The following tables are the primary fact tables available in the VersionOne 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.