Created On:  6/11/2012

Problem:

How can I get traced requirement description and tag information from a Caliber datamart extract?

Resolution:

Below is the SQL query and relationship that you will need once your datamart is working:
Relationship:
Build a relationship between RequirementInfo.RequirementID and Trace.Root_Element_ID
Query Required:
SELECT RequirementInfo.Requirement_ID, Trace.Root_Element_ID, RequirementInfo.Baseline_ID, RequirementInfo.Requirement_Name, RequirementInfo.Description, RequirementInfo.Type, RequirementInfo.Tag_ID, Trace.trace_id, Trace.Root_Element_Name, Trace.Root_Element_Type, Trace.Root_Element_Status, Trace.Root_Element_Project_Name, Trace.Trace_Element_ID, Trace.Trace_Element_Type, Trace.Trace_Element_Status, Trace.Trace_Element_Name, Trace.Trace_Element_Project_Name, Trace.Direction, Trace.Depth, Trace.Circular, Trace.Suspect
FROM RequirementInfo INNER JOIN Trace ON RequirementInfo.Requirement_ID = Trace.Root_Element_ID;
This query will pull requirement id, baseline, requirement name, description, type and tag from the requirementinfo table and all fields from the Trace table.