The Relationships tool will examine all the combinations of first, second, and cousin (3rd) degree relationships, within your cohort. The results will be presented as the total number of each type of relationship, within your cohort, aggregated by the degree of relationship. These instructions assume that you have an existing query for which you wish to examine relationships. If you have just finished creating the query or have just run the query and are currently on the totals page, start with step 5 below.

To examine the relationships among patients selected in a query:

  1. Click on the Query UPDBL button on the upper right side of the window or click on the Query UPDBL button in the lower right corner of the window. The Saved Queries window open.


  1. Find the query representing the cohort for which you wish to examine relationships in the Saved Queries list and click on it.
  2. Click on the Load button on the right side of the Saved Queries window to load the query. The Cohort Builder window will open, listing the criteria for the selected query.


  1. Click on the button marked Select and Run Aggregation to turn to the Totals window.


  1. Click on the button marked Examine Relationships to turn to the Examine Relationships page.


  1. Click on the Determine Relationships button. The relationship totals will be displayed in the Relationship Within Selected Cohort grid. (Be patient, this may take a few minutes.)


It is suggested that you only run the relationship analysis tool on cohorts that contain 250,000 or fewer individuals. If you attempt to run the tool on a larger group, the analysis may take some time. If the analysis is taking too long, you may stop it by clicking on the Cancel button (just to the right of the Determine Relationships button).

  1. The Relationships tool has now done its work. You may stop here, or — if you would like to download the results of the analysis as an Excel file — click on the Download Results button. A dialog will open asking if you want to open or save the resulting Excel file.


  1. Select Save. A dialog will open asking you to select the location where you want to save the results file.


The File Download dialog may appear different depending on which browser you are using. You may also choose to open the file instead of saving it.

  1. Choose a location, save the file and open it in Excel (or another spreadsheet application that can read Excel files) to view the resulting spreadsheet.

Contact Us

Research Informatics Director
Andrew Post, MD, PhD

Research Informatics Associate Director
Shirleen Hewitt, DBA


HCI Senior Director Oversight
Aik Choon Tan, PhD

Faculty Advisory Committee Chair
Aik Choon Tan, PhD

Faculty Advisory Committee Members
HCI Research Executive Committee