Skip to main content
System StatusContact Support
VersionOne 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.

  • Was this article helpful?