Custom Fields
This topic explains how to generate report against custom fields in Agility.
The data mart facilitates reporting against custom fields and custom drop-downs on the following assets: Backlog Defect Environment Issue Iteration Member Project Regression Suite Request Story Task Test Test Set Theme Custom Fields and Drop-downs are available on Dimension Tables and Fact Tables.
Dimensions
Dimension Tables contain columns for the following:
- Check box
- Date
- Text
- Number
- Custom drop-down values
This allows you to create reports on the current values for these attributes.
Facts
Fact Tables contain columns for the following
- Check box
- Number
- Custom drop-down values
The chart below indicates which Fact table are altered when custom fields appear on specific assets
| Fact.Issue | Fact.PrimaryWorkitem | Fact.Request | Fact.Task | Fact.Test | Fact.Workitem | |
| Story | X | X | ||||
| Defect | X | X | ||||
| TestSet | X | X | ||||
| PrimaryWorkitem | X | X | ||||
| Task | X | X | ||||
| Test | X | X | ||||
| Issue | X | |||||
| Request | X |
Naming
Data Mart column names for custom fields are generated from the System Name for the field defined in the VersionOne core application. Here are some examples:
- A custom numeric field on PrimaryWorkitems (Stories and Defects) called Business Values would results in the column Custom_BusinessValue on Fact.PrimaryWorkitem, Fact.Workitem, and Dim.PrimaryWorkitem.
- A custom drop down on Test called Method would result in 2 columns on Dim.SecondaryWorkitem; one for the value called Custom_MethodName and one for the Foreign Key relationship called Custom_MethodKey. On Fact.Test and Fact.Workitem, there would be one column, Custom_MethodKey, that contains the foreign key value.
- A custom check box on PrimaryWorkitems (Stories and Defects) called Documentation Impact, would result in the column Custom_DocumentationImpactKey on Fact.PrimaryWorkitem, Fact.Workitem, and Dim.PrimaryWorkitem and a foreign key relationship to Dim.BooleanAttribute on BooleanAttributeKey
- A custom text field on Project called Code Name, would only appear on Dim.Project as Custom_CodeName.
Prior to the Spring 2011 release, the data mart only supported custom fields on the following Digital.ai Agility assets
- Stories (aka Backlog Items)
- Defects
- TestSets
- Task
- Test
- Issue
- Request
Prior to the Spring 2011 release, the following custom fields types are available in the data mart
- Custom Numbers
- Custom Drop-downs
- Custom Check boxes