Fact Epic Test
The Fact.EpicTest table contain metrics available on Tests on Epics Each row in the table represents a single Epic Test on a given day. All metrics in the table are semi-additive, meaning that are cumulative only for a given day. There are no default metrics on this table.
Table Description
The following table describes the columns available in the default table.
| Column Name | Description | Datatype | Foreign Key To |
|---|---|---|---|
| DateKey | Date of this measure | int | Dim.Date |
| WorkitemKey | Data Mart identifier for the Test | int | |
| AssetTypeKey | Data Mart identifier for the type of workitem | int | Dim.AssetType |
| EpicKey | Data Mart identifier for the PrimaryWorkitem that owns this Test | int | Dim.Epic |
| SecondaryWorkitemKey | Data Mart identifier for the Test | int | Dim.EpicTest |
| ProjectKey | Data Mart identifier for the Project containing this Test | int | Dim.Project |
| TestStatusKey | Data Mart identifier for the Test status | int | Dim.TestStatus |
| TestTypeKey | Data Mart identifier for the Test Type | int | Dim.TestType |
| SecondaryAssetStateKey | Data Mart identifier for the asset state of the Test | int | Dim.AssetState |