Fact.Request
The Fact.Request table captures information about daily changes to requests. Each row in the table represents a single Request on a given day. All metrics in the table are semi-additive, meaning that are cumulative only for a given day. Supported Custom Fields are also available 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 |
| RequestKey | Datamart identifier for the request | int | Dim.Request |
| ProjectKey | Datamart identifier for the project containing the request | int | Dim.Project |
| OwnerKey | Datamart identifier for the member that owns the request | int | Dim.Member |
| ResolutionKey | Datamart identifier for the request resolution | int | Dim.RequestResolution |
| SourceKey | Datamart identifier for the source of this request | int | Dim.WorkitemSource |
| PriorityKey | Datamart identifier for the request priority | int | Dim.RequestPriority |
| StatusKey | Datamart identifier for the request status | int | Dim.RequestStatus |
| CategoryKey | Datamart identifier for the request category | int | Dim.RequestCategory |
| AssetStateKey | Datamart identifier for the asset state of this request | int | Dim.AssetState |