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 Digital.ai Agility 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 Request. The 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. |
Detail Data Objects
Detail Data Objects contain attribute values for the Agility 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 Agility 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 Agility 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 Agility 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 |