Target Table Star Schemas
Measure Tables
ChangeMgmt_Measure Table
The ChangeMgmt_Measure measure table contains metrics collected from ClearQuest.
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Submitdate_fk |
|
|
Reference |
SubmitDate_Dim |
|
State_fk |
|
|
Reference |
State_Dim |
|
Severity_fk |
|
|
Reference |
Severity_Dim |
|
Project_fk |
|
|
Reference |
Project_Dim |
|
Owner_fk |
|
|
Reference |
Owner_Dim |
|
Iteration_fk |
|
|
Reference |
Iteration_Dim |
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Num Change Requests |
Existence measure |
|
Integer |
|
|
ClearCase_Measure Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Artifactname_fk |
|
|
Reference |
ArtifactName_Dim |
|
Artifacttype_fk |
|
|
Reference |
ArtifactType_Dim |
|
Branch_fk |
|
|
Reference |
Branch_Dim |
|
Build_fk |
|
|
Reference |
Build_Dim |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
Lines Changed |
|
|
Integer |
|
|
Lines Deleted |
|
|
Integer |
|
|
Lines Inserted |
|
|
Integer |
|
|
Num ClearCase Data |
Existence measure |
|
Integer |
|
|
Operation_fk |
|
|
Reference |
Operation_Dim |
|
Operationdate_fk |
|
|
Reference |
Operationdate |
|
Project_fk |
|
|
Reference |
Project_Dim |
|
User_fk |
|
|
Reference |
Owner_Dim |
|
Version_fk |
|
|
Reference |
Version_Dim |
|
Vob_fk |
|
|
Reference |
Vob_Dim |
|
|
|
|
|
|
|
Coverage_Measure Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Artifactname_fk |
|
|
Reference |
ArtifactName_Dim |
|
Artifacttype_fk |
|
|
Reference |
ArtifactType_Dim |
|
Build_fk |
|
|
Reference |
Build_Dim |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
Functions Hit |
|
|
Integer |
|
|
Functions Missed |
|
|
Integer |
|
|
Lines Hit |
|
|
Integer |
|
|
Lines Missed |
|
|
Integer |
|
|
Num Coverage Data |
Existence measure |
|
Integer |
|
|
Parentmodule_fk |
|
|
Reference |
ParentModule_Dim |
|
Parentsource_fk |
|
|
Reference |
ParentSource_Dim |
|
Project_fk |
|
|
Reference |
Project_Dim |
|
Design_Measure Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Abstract_fk |
|
|
Reference |
Abstract_Dim |
|
Artifactname_fk |
|
|
Reference |
ArtifactName_Dim |
|
Artifacttype_fk |
|
|
Reference |
ArtifactType_Dim |
|
Build_fk |
|
|
Reference |
Build_Dim |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
Concurrency_fk |
|
|
Reference |
Concurreny_Dim |
|
Exportcontrol_fk |
|
|
Reference |
ExportControl_Dim |
|
Global_fk |
|
|
Reference |
Global_Dim |
|
Isucpkg_fk |
|
|
Reference |
IsUCPackage |
|
Kind_fk |
|
|
Reference |
Kind_Dim |
|
Num Design Item |
Existence measure |
|
Integer |
|
|
Parentclass_fk |
|
|
Reference |
ParentClass_Dim |
|
Parentpackage_fk |
|
|
Reference |
ParentPackage_Dim |
|
Persistence_fk |
|
|
Reference |
Persistence_Dim |
|
Project_fk |
|
|
Reference |
Project_Dim |
|
Stereotype_fk |
|
|
Reference |
Stereotype_Dim |
|
Feature_Req_Measure Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Artifactname_fk |
|
|
Reference |
ArtifactName_Dim |
|
Artifacttype_fk |
|
|
Reference |
ArtifactType_Dim |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
Cost_fk |
|
|
Reference |
Cost_Dim |
|
Difficulty_fk |
|
|
Reference |
Difficulty_Dim |
|
Iteration |
|
|
Reference |
Iteration_Dim |
|
Level_fk |
|
|
Reference |
Level_Dim |
|
Num Feature Reqs |
Existence measure |
|
Integer |
|
|
Owner_fk |
|
|
Reference |
Owner_Dim |
|
Priority_fk |
|
|
Reference |
Prioirity_Dim |
|
Project_fk |
|
|
Reference |
Project_Dim |
|
Stability_fk |
|
|
Reference |
Stability_Dim |
|
State_fk |
|
|
Reference |
State_Dim |
|
Purify_Measure Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Artifactname_fk |
|
|
Reference |
ArtifactName_Dim |
|
Artifacttype_fk |
|
|
Reference |
ArtifactType_Dim |
|
Build_fk |
|
|
Reference |
Build_Dim |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
Description_fk |
|
|
Reference |
Description_Dim |
|
Num Purify Data |
Existence measure |
|
Integer |
|
|
Project_fk |
|
|
Reference |
Project_Dim |
|
testCase_Measure Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
AcceptanceCriteria_fk |
|
|
Reference |
AcceptanceCriteria_fk |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
configured_fk |
|
|
Reference |
Description_Dim |
|
numTestCases |
Existence measure |
|
Integer |
|
|
Owner_fk |
|
|
Reference |
Owner_Dim |
|
Suspect_fk |
|
|
Reference |
Suspect_Dim |
|
TestCaseName |
|
|
Reference |
TestCaseName_Dim |
|
UseCase_Measure Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Actualiteration_fk |
|
|
Reference |
ActualIteration_Dim |
|
Artifactname_fk |
|
|
Reference |
ArtifactName_Dim |
|
Artifacttype_fk |
|
|
Reference |
ArtifactType_Dim |
|
Calendardate_fk |
|
|
Reference |
Calendardate |
|
Coll_instance_log_id |
|
|
String |
|
|
Collectiondate_fk |
|
|
Reference |
Collectiondate |
|
Cost_fk |
|
|
Reference |
Cost_Dim |
|
Difficulty_fk |
|
|
Reference |
Difficulty_Dim |
|
Iteration |
|
|
Reference |
Iteration_Dim |
|
Level_fk |
|
|
Reference |
Level_Dim |
|
Num Use Case |
Existence measure |
|
Integer |
|
|
Owner_fk |
|
|
Reference |
Owner_Dim |
|
Priority_fk |
|
|
Reference |
Priority_Dim |
|
Project_fk |
|
|
Reference |
Project_Dim |
|
Stability_fk |
|
|
Reference |
Stability_Dim |
|
State_fk |
|
|
Reference |
State_Dim |
|
Dimension Tables
Abstract_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Abstract |
|
|
String |
|
Y |
AcceptanceCriteria_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
AcceptanceCriteria |
|
|
String |
|
Y |
ActualIteration_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Actual Iteration |
|
|
String |
|
Y |
ArtifactName_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Artifact Name |
|
|
String |
|
Y |
ArtifactType_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Artifact Type |
|
|
String |
|
Y |
Branch_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Branch |
|
|
String |
|
Y |
Build_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Build |
|
|
String |
|
Y |
Calendardate Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Calendardate_daynum |
|
|
Integer |
|
|
Calendardate_dayofmonth |
|
|
Integer |
|
|
Calendardate_dayofyear |
|
|
Integer |
|
|
Calendardate_daystr |
|
|
String |
|
|
Calendardate_monthly |
|
|
Integer |
|
|
Calendardate_mthnum |
|
|
Integer |
|
|
Calendardate_mthofyear |
|
|
Integer |
|
|
Calendardate_mthstr |
|
|
String |
|
|
Calendardate_name |
|
|
String |
|
Y |
Calendardate_qtrofyear |
|
|
Integer |
|
|
Calendardate_quarterly |
|
|
Integer |
|
|
Calendardate_quarternum |
|
|
Integer |
|
|
Calendardate_quarterstr |
|
|
String |
|
|
Calendardate_weekly |
|
|
Integer |
|
|
Calendardate_weeknum |
|
|
Integer |
|
|
Calendardate_weekofyear |
|
|
Integer |
|
|
Calendardate_weekstr |
|
|
String |
|
|
Calendardate_yearly |
|
|
Integer |
|
|
Calendardate_yearnum |
|
|
Integer |
|
|
Calendardate_yearstr |
|
|
String |
|
|
Collectiondate Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Collectiondate_daynum |
|
|
Integer |
|
|
Collectiondate_dayofmonth |
|
|
Integer |
|
|
Collectiondate_dayofyear |
|
|
Integer |
|
|
Collectiondate_daystr |
|
|
String |
|
|
Collectiondate_monthly |
|
|
Integer |
|
|
Collectiondate_mthnum |
|
|
Integer |
|
|
Collectiondate_mthofyear |
|
|
Integer |
|
|
Collectiondate_mthstr |
|
|
String |
|
|
Collectiondate_name |
|
|
String |
|
Y |
Collectiondate_qtrofyear |
|
|
Integer |
|
|
Collectiondate_quarterly |
|
|
Integer |
|
|
Collectiondate_quarternum |
|
|
Integer |
|
|
Collectiondate_quarterstr |
|
|
String |
|
|
Collectiondate_weekly |
|
|
Integer |
|
|
Collectiondate_weeknum |
|
|
Integer |
|
|
Collectiondate_weekofyear |
|
|
Integer |
|
|
Collectiondate_weekstr |
|
|
String |
|
|
Collectiondate_yearly |
|
|
Integer |
|
|
Collectiondate_yearnum |
|
|
Integer |
|
|
Collectiondate_yearstr |
|
|
String |
|
|
Concurrency_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Concurrency |
|
|
String |
|
Y |
Configured_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Configured |
|
|
String |
|
Y |
Cost_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Cost |
|
|
String |
|
Y |
Description_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Description |
|
|
String |
|
Y |
Difficulty_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Difficulty |
|
|
String |
|
Y |
ExportControl_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
ExportControl |
|
|
String |
|
Y |
Global_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Global |
|
|
String |
|
Y |
IsUCPackage_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Is Use Case Pkg |
|
|
String |
|
Y |
Iteration_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
iteration |
|
|
String |
|
Y |
Kind_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Kind |
|
|
String |
|
Y |
Level_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Level |
|
|
String |
|
Y |
Operation_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Operation |
|
|
String |
|
Y |
Operationdate Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Operationdate_daynum |
|
|
Integer |
|
|
Operationdate_dayofmonth |
|
|
Integer |
|
|
Operationdate_dayofyear |
|
|
Integer |
|
|
Operationdate_daystr |
|
|
String |
|
|
Operationdate_monthly |
|
|
Integer |
|
|
Operationdate_mthnum |
|
|
Integer |
|
|
Operationdate_mthofyear |
|
|
Integer |
|
|
Operationdate_mthstr |
|
|
String |
|
|
Operationdate_name |
|
|
String |
|
Y |
Operationdate_qtrofyear |
|
|
Integer |
|
|
Operationdate_quarterly |
|
|
Integer |
|
|
Operationdate_quarternum |
|
|
Integer |
|
|
Operationdate_quarterstr |
|
|
String |
|
|
Operationdate_weekly |
|
|
Integer |
|
|
Operationdate_weeknum |
|
|
Integer |
|
|
Operationdate_weekofyear |
|
|
Integer |
|
|
Operationdate_weekstr |
|
|
String |
|
|
Operationdate_yearly |
|
|
Integer |
|
|
Operationdate_yearnum |
|
|
Integer |
|
|
Operationdate_yearstr |
|
|
String |
|
|
Owner_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Owner |
|
|
String |
|
Y |
ParentClass_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Parent Class |
|
|
String |
|
Y |
ParentModule_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Parent Module |
|
|
String |
|
Y |
ParentPackage_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Parent Package |
|
|
String |
|
Y |
ParentSource_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Parent Source |
|
|
String |
|
Y |
Persistence_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Persistence |
|
|
String |
|
Y |
PlannedIteration_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
PlannedIteration |
|
|
String |
|
Y |
Priority_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Priority |
|
|
String |
|
Y |
Project_Dim Table
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Project |
|
|
String |
|
Y |
Severity_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Severity |
|
|
String |
|
Y |
..
..
Stability_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Stability |
|
|
String |
|
Y |
..
..
State_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
State |
|
|
String |
|
Y |
..
..
Stability_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Stability |
|
|
String |
|
Y |
..
..
State_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
State |
|
|
String |
|
Y |
..
..
Stereotype_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Stereotype |
|
|
String |
|
Y |
..
..
Submitdate Table
. ..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Severity |
|
|
String |
|
Y |
..
..
Suspect_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Suspect |
|
|
String |
|
Y |
..
..
testCaseName_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
testCaseName |
|
|
String |
|
Y |
..
..
Version_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Version |
|
|
String |
|
Y |
..
..
Vob_Dim Table
..
Display Name |
Description |
Non-additive |
Type |
Reference Type (Table it References) |
Unique Key |
Vob |
|
|
String |
|
Y |
..
..
..