Joins¶
A join is an association between tables that allow Ad Hoc views to show data across related tables. A join tree is a group of tables that are interconnected, directly or indirectly, by joins.
The aPriori Ad Hoc Data Domain has a single join tree that interconnects all related tables.
To examine a JoinTree:¶
- Open the aPriori Ad Hoc Data Domain to the Domain Designer. For more information, see To Open the Domain Designer.
-
In the Domain Designer menu bar, click Joins.
The Joins tab opens.
The aPriori Ad Hoc Data Domain uses one join tree, JoinTree_1, to interconnect all tables in the Domain.
The Joins tab contains the Data Structure panel and the Joins Design panel.
The Data Structure panel, on the left side of the page, shows all tables in the Domain. Any tables that are not joined, are included in the node for the Domain. Tables that are joined are included in join tree nodes that appear below the node for the Domain.
The Joins Design panel, to the right of the Data Structure panel, shows the joins trees and joins in the domain. It also shows the settings for each join. For more information, see the Jaspersoft documentation.
This table shows the joins in the aPriori Ad Hoc Data Domain. Each join is based on one of these tables:
- scenario_facts_base
- process_facts_base
- operation_facts_base
- export_event_to_scenario_facts
- container_structure_table
| Left Table | Right Table | Type |
|---|---|---|
| cost_type:id | scenario_facts_base:cost_type_id | Inner |
| export_event_to_scenario_facts:scenario_facts_id | scenario_facts_base:id | Inner |
| export_event:id | export_event_to_scenario_facts:export_event_id | Inner |
| costed_date:id | scenario_facts_base:costed_date_id | Inner |
| export_date:id | export_event:export_date_id | Inner |
| export_set:id | export_event:export_set_id | Inner |
| process_group:id | scenario_facts_base:process_group_id | Inner |
| material:id | scenario_facts_base:material_id | Inner |
| material_catalog:id | scenario_facts_base:material_catalog_id | Inner |
| quote_reference:id | scenario_facts_base:quote_reference_id | Inner |
| scenario:id | scenario_facts_base:scenario_id | Inner |
| vpe:id | scenario_facts_base:vpe_id | Inner |
| scenario_facts_base:id | process_facts_base:scenario_facts_id | Left Outer |
| process:id | process_facts_base:process_id | Right Outer |
| machine:id | process_facts_base:machine_id | Right Outer |
| process_facts_base:id | operation_facts_base:process_facts_id | Left Outer |
| operation:id | operation_facts_base:operation_id | Right Outer |
| process_vpe:id | process_facts_base:process_vpe_id | Right Outer |
| costed_by_user:costed_by_user_id | scenario_facts_base:costed_by_user_id | Inner |
| created_by_user:created_by_user_id | scenario_facts_base:created_by_user_id | Inner |
| created_date:id | scenario_facts_base:created_date_id | Inner |
| last_saved_by_user:last_saved_by_user_id | scenario_facts_base:last_saved_by_user_id | Inner |
| last_saved_date:id | scenario_facts_base:last_saved_date_id | Inner |
| latest_export_event:id | export_event:id | Inner |
| last_assigned_date:id | scenario_facts_base:last_assigned_date_id | Inner |
| all_latest_scenarios:export_event_id | export_event:id | Inner |
| all_latest_scenarios:scenario_facts_id | scenario_facts_base:id | Inner |
| assignee:assignee_id | scenario_facts_base:assignee_id | Inner |
| export_event:id | container_structure_tbl:export_event_id | Left Outer |
| scenario_facts_base:id | container_structure_tbl:child_scenario_facts_id | Left Outer |
| dtc_metric:scenario_facts_id | scenario_facts_base:id | Right Outer |
| process_group1:id | dtc_metric:process_group_id | Right Outer |
| MCH_Failed_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Not_Supported_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_DFM_Risk_Score:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_DFM_Risk_Rating:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Machining_Issues_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Sharp_Corner_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_LD_Ratio_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Obstructed_Surface_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Minimum_Floor_Radius_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Slot_Shape_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Dovetail_Zero_Tool_Neck_Diameter_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Obstructed_Volume_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Keyseat_Mill_Accessibility_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Machining_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Tolerances:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Tolerances_Driving_Specialized_Finishing:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Tolerances_Driving_Specialized_Finishing_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_CMC_Ops_GCD_count:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Contour_Milled_Corner_Ops:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Contour_Milled_Corners_Ops:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Contouring_CMC_time_otal_cycle_time:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Contouring_Operations:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Contouring_Ops:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Contouring_Ops_GCD_count:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Setups:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Standard_Hole_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Non_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Non_Standard_Hole_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Standard_Fillet_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Non_Standard_Fillet_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Non_Standard_Fillet_Sizes_Non_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Non_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Non_Standard_Hole_Sizes_Non_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Standard_Fillet_Sizes_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Setups_Machined_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| MCH_Standard_Hole_Sizes_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Casting_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Failed_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Machined_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Not_Supported_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_DFM_Risk_Score:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_DFM_Risk_Rating:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Casting_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Casting_Issues_Casting_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Draft_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Hole_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Blind_Hole_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Maximum_Hole_Depth:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Minimum_Hole_Diameter:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Hole_Proximity_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_LD_Ratio:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Machining_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Machining_Issues_Machined_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Material_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Obstructed:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Radius_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Internal_Edge_Radius_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_External_Edge_Radius_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Sharp_Edges_on_Parting_Line:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Sharp_Corners:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Slides:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Cores:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Machining_Cost_Casting_Cost:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Machining_Cycle_Time:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Machining_cycle_time_total_cycle_time:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Machined_GCDs_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Tolerance_Count:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Tolerance_Driving_Machining:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Tolerance_Driving_Specialized_Finishing:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Tolerances_driving_machining_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Tolerances_Driving_Specialized_Finishing_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Contour_Milled_Corner_Ops:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Contour_Milled_Corners_Ops:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Contouring_CMC_time_total_cycle_time:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Contouring_Operations:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Contouring_Ops:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Contouring_Ops_GCD_count:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_CMC_Ops_GCD_count:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Setups:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Standard_Hole_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Non_Standard_Hole_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Non_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Standard_Fillet_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Non_Standard_Fillet_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Non_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Setups_Machined_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Standard_Hole_Sizes_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Non_Standard_Hole_Sizes_Non_Standard_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Standard_Fillet_Sizes_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| CST_Non_Standard_Fillet_Sizes_Non_Standard_Fillets:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Failed_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Not_Supported_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Plastics_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_DFM_Risk_Score:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_DFM_Risk_Rating:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Plastic_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Draft_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Hole_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Blind_Hole_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Hole_Depth_to_Diameter_Ratio_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Hole_Proximity_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Radius_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Internal_Edge_Radius_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_External_Edge_Radius_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Sharp_Edges_on_Parting_Line:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Material_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Plastic_Issues_Plastic_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Slides:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Lifters:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Threading_Mechanisms:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Grills:scenario_facts_id | scenario_facts_base:id | Right Outer |
| PLS_Ribs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Failed_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Machined_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Not_Supported_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Sheet_Metal_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_DFM_Risk_Score:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_DFM_Risk_Rating:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Sheet_Metal_Issues:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Machining_Cost_Sheet_Metal_Cost:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Machining_Cycle_Time:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Machining_cycle_time_total_cycle_time:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Machined_GCDs_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Tolerance_Count:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Tolerance_Driving_Machining:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Tolerance_Driving_Specialized_Finishing:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Tolerances_driving_machining_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Tolerances_Driving_Specialized_Finishing_Total_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Bends:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Unique_Bend_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Hole_Sizes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Setups:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Setups_Machined_GCDs:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Unique_Bend_Sizes_Bends:scenario_facts_id | scenario_facts_base:id | Right Outer |
| SHM_Hole_Sizes_Holes:scenario_facts_id | scenario_facts_base:id | Right Outer |
| scenario:id | user_to_scenario:scenario_id | Inner |