Custom Fields

Dimensions

Dimension Tables contain columns for the following:

• Checkbox
• Date
• Text
• Number
• Custom dropdown values

This allows you to create reports on the current values for these attributes.

Facts

Fact Tables contain columns for the following

• Checkbox
• Number
• Custom dropdown values

The chart below indicates which Fact table are altered when custom fields appear on specific assets

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.