Skip to main content
System StatusContact Support
VersionOne Community

Fact.Request

This feature is available in Enterprise and Ultimate editions.

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
  • Was this article helpful?