Skip to main content
System StatusContact Support
VersionOne Community

Data Source Objects

The sections below describe the various data sources available for use when create a report definition.  Click here to view the schema diagram.

In most cases Data Objects in Custom Reporting are directly related to tables in the VersionOne Data Mart database and are organized into categories.

A Report On

Data Object Name Data Mart Database Table Name Information
Build Runs Fact.BuildRun A record of Build Runs in your environment. Each row in the table represents a single build run recorded in VersionOne.
Effort Trends Fact.Effort The amount of time spent working on a feature or defect. Sometimes referred to as Actuals. In the run-time application effort is accumulated in the Done field. Each row represents a single entry in VersionOne. All numeric columns are additive, meaning that they accumulate over time.
Epic Days In Fact.EpicDaysInView The number of Days an Epic spent in a given status value. 
Epic Trends Fact.Epic Use this object to create reports that trend VersionOne Epic data over time. You can also use this object to report on Epic attribute values on a given day. In this scenario, you need to specify a Date filter that identifies the date of interest. Each row in this table represents a single Epic on a given day. All numeric columns are semi-additive, meaning that are cumulative only for a given day.
Goal Assignment Bridge.PrimaryWorkitemGoal Create reports on Goals defined in VersionOne and workitems associated with them.
Issue Trends Fact.Issue The daily changes to Issues. Each row represents a single Issue on a given day. All numeric columns are semi-additive, meaning that are cumulative only for a given day.
Member Capacity Fact.Capacity Capacity, or availability, as reported by Members. Each row in the table represents a single capacity entry from VersionOne. All numeric columns are additive, meaning they accumulate over time
Members of a Member Group Bridge.MemberGroup Create reports on Member Groups and the people that belong to them.
Project Summary Trends Fact.ProjectSummary Use this object to create reports that trend VersionOne Project Summary data over time.
Projects in a Program Bridge.ProjectProgram Create reports on Programs and the Projects they contain.
Request Trends Fact.Request Create a report on Workitem related to a RequestThe daily changes to Requests. Each row represents a single Request on a given day. All numeric columns are semi-additive, meaning that are cumulative only for a given day.
Requested Workitem Bridge.PrimaryWorkitemRequest Create a report on Workitem related to a Request
Workitem Dependency Bridge.PrimaryWorkitemDependencies Create reports on upstream and downstream dependencies between workitems (Story, Defect, TestSet) 
TestRun Trend Fact.TestRun A record of TestRuns in your environment. Each row in the table represents a single test run recorded in VersionOne.
Workitems Blocked By Issue Bridge.PrimaryWorkitemBlockedByIssue Relate a Blocked Workitem to the Blocking Issue on a given date
Workitem Resolves Issue Bridge.PrimaryWorkitemResolvedIssue Relate a Workitem to the Issue it resolves
Workitem Days In Fact.PrimaryWorkitemDaysInView Tee number of days a workitem (Story, Defect, TestSet) spent in a given status value.
Workitem Trends Fact.Workitem This object trends VersionOne workitem data over time.  Each row in this table represents a single workitem on a given day.  All numeric columns are semi-additive, meaning that are cumulative only for a given day.  The workitems available are Stories, Defects, TestSets, Tasks, and Tests.  You can also use this object to report on workitem attribute values on a given day. In this scenario, you need to specify a Date filter that identifies the date of interest.

Detail Data Objects

Detail Data Objects contain attribute values for the VersionOne data type (asset type) specified.  The values in the table are current as of the last successful Data Mart ETL load. The date and time of the last successful ETL load is visible at the bottom of the page.

The following table indicates how these Data Objects map to the Data Mart database tables and to VersionOne data types. 

Data Object Name Data Mart Database Table Name VersionOne System Name
Build Project Details Dim.BuildProject BuildProject
Date Details Dim.Date  
Environment Details Dim.Environment Environment
Epic Details Dim.EpicView Epic
Feature Group Details Dim.ThemeView Theme
Goal Details Dim.Goal Goal
Issue Details Dim.Issue Issue
Iteration Details Dim.Iteration Timebox
Member Details Dim.Member Member
Member Group Details Dim.MemberGroup MemberGroup
Program Details Dim.Program ScopeLabel
Project Details Dim.MyProject Scope
Regression Plan Details Dim.RegressionPlan RegressionPlan
Regression Suite Details Dim.RegressionSuite RegressionSuite
Regression Test Details Dim.RegressionTest RegressionTest
Request Details Dim.Request Request
Schedule Details Dim.Schedule Schedule
Task and Test Details Dim.SecondaryWorkitem Task and Test
Team Details Dim.Team Team
Test Suite Details Dim.TestSuite TestSuite
Workitem Details Dim.PrimaryWorkitem PrimaryWorkitem

The following Data Source objects do not have a corresponding VersionOne system data type or tables in the Data Mart database.

Table Name Information
Customer Details This is a View on the Dim.Member table with Attributes renamed
Verified By Details This is a View on the Dim.Member table with Attributes renamed

Quick Reports Data Objects

Quick Report data objects have no corresponding data mart table. They are predefined queries that allow you to quickly build a report on a given type. You cannot add or remove columns and you can only filter on data that is returned by the query.

Data Object Name A predefined query for creating a report on...
Blocked Workitem Report Workitems and the issues that block them.
Build Run Report BuildRun
Capacity Report Capacity
Member Effort Report Effort by Member
Request Report Daily changes to Requests
Requested Workitem Report Workitems associated with Request
Story Dependency Report Story dependency
Workitem Trend Report for a Project, Epic, or Feature Group daily changes to Workitems

All Data Objects

As mentioned above, the All category contains all data objects available in Custom Reporting. However, this section only describes the data objects that have not already been described elsewhere.

Value Data Objects contains the list values from VersionOne drop downs. All of these data objects end with the term "Values". The following table indicates how these Data Objects map to the Data Mart database tables

Data Object Name Data Mart Database Table Name Information
Asset Type Values Dim.AssetType The types of assets available for reporting
Attachment Category Values Dim.AttachmentCategory Values defined in the Attachment Type or Attachment Category drop-down list
BooleanAttribute Dim.BooleanAttribute Values for boolean, or check box, attributes.
Build Run Source Values Dim.BuildSource Values defined in the Build Source drop-down list
Build Run Status Values Dim.BuildStatus Values defined in the Build Status drop-down list
Defect Resolution Values Dim.DefectResolution Values defined in the Defect Resolution drop-down list
Defect Type Values Dim.DefectType Values defined in the Defect Type drop-down list
Epic Priority Values Dim.EpicPriority Values defined in the Epic Priority drop-down list
Epic Status Values Dim.EpicStatus Values defined in the Epic Status drop-down list
Epic Type Values Dim.EpicType Values defined in the Epic Type or Epic Category drop-down list
Feature Group Risk Values Dim.ThemeComplexity Values defined in the Workitem Risk drop-down list
Feature Group Source Values Dim.ThemeSource Values defined in the Theme Source drop-down list
Feature Group Status Values Dim.ThemeStatus Values defined in the Theme Status drop-down list
Feature Group Type Values Dim.ThemeType Values defined in the Theme Type or Theme Category drop-down list
Goal Priority Values Dim.GoalPriority Values defined in the Goal Priority drop-down list
Goal Type Values Dim.GoalType Values defined in the Goal Type or Goal Category drop-down list
Issue Category Values Dim.IssueCategory Values defined in the Issue Type or Issue Category drop-down list
Issue Priority Values Dim.IssuePriority Values defined in the Issue Priority drop-down list
Issue Resolution Values Dim.IssueResolution Values defined in the Issue Resolution drop-down list
Issue Status Values Dim.IssueStatus Values defined in the Issue Status drop-down list
Note Category Values Dim.NoteCategory Values defined in the Note Type or Note Category drop-down list
Project Status Values Dim.ProjectStatus Values defined in the Project Status drop-down list
Regression Test Status Values Dim.RegressionTestStatus Values defined in the Regression Test Status drop-down list
Request Category Values Dim.RequestCategory Values defined in the Request Type or Request Category drop-down list
Request Priority Values Dim.RequestPriority Values defined in the Request Priority drop-down list
Request Resolution Values Dim.RequestResolution Values defined in the Request Resolution drop-down list
Request Status Values Dim.RequestStatus Values defined in the Request Status drop-down list
Story Complexity Values Dim.StoryRisk Values defined in the Workitem Risk drop-down list
Story Type Values Dim.StoryType Values defined in the Story Type or Story Category drop-down list
Story Dependencies Bridge.StoryDependsOnStory

Create reports on dependencies between Stories.  

As of the Fall 2014 release (14.3.x) this data source has been deprecated and will be removed in a future release.  The replacement data source is Primary Workitem Dependencies.

Task Source Values Dim.TaskSource Values defined in the Task Source drop-down list
Task Status Values Dim.TaskStatus Values defined in the Task Status drop-down list
Task Type Values Dim.TaskType Values defined in the Task Category drop-down list
Test Status Values Dim.TestStatus Values defined in the Test Status drop-down list
Test Type Values Dim.TestType Values defined in the Test Type drop-down list
Workitem Priority Values Dim.WorkitemPriority Values defined in the Workitem Priority drop-down list
Workitem Source Values Dim.WorkitemSource Values defined in the Workitem Source drop-down list
Workitem Status Values Dim.WorkitemStatus Values defined in the Workitem Status drop-down list
  • Was this article helpful?