Page Comparison

{anchor:top}
h2. Creating the Intersect Sub Query
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* Click on the {color:#357CB6}Create{color} link *Create* link and select *Report* to begin writingbuilding your report.
{column}
{column: width=70%}
!01create01.png! 
{column}
{section}

{section}
{column: width=30%}	 
*2.* You should now be on the Initialise Report page. LeaveSelect the *Drag and Drop Builder* selected as the build tool.
{column}
{column: width=70%}
!02.png! 
{column}
{section}

{section}
{column: width=30%}
*3.* Select *Ski TutorialTeam* as the Source System and Database View (if not already selected).

*4.* Now click either of the !step_right_on.png! buttonsbutton to proceed.
{column}
{column: width=70%}
!02initialise2a.png|thumbnail,border=1! 
{column}
{section}

{section}
{column:width=30%}	 
*5.* Tick the checkbox next to *Sub Queries* to enable them. There should now be a *Sub Query* link at the top of the page.	
{column}
{column:width=70%}
!03option.png!
{column}
{section}
{section}
{column:width=30%} 
*6.* Click on the *Sub Query* link. This will open the *Sub Query Type* menu.

*7.* Set the Type to *Intersect*.

*8.* Click *Submit*.

*9.* You should now have a *Master Query* Tab and a *Sub Query* Tab. Click on the *Master Query* tab to setup the query.
{column}
{column:width=70%}
!04intersect.png|thumbnail,border=1!
{column}
{section}
{section}
{column:width=30%}	 
*10.* Drag and drop the !rpt_dim.png! *Athlete ID*, !rpt_dim.png! *First Name*, and !rpt_dim.png! *Last Name* dimensions into the *Column Fields* area. 

*11.* Drag and drop the !rpt_dim.png! *Year* dimension into the *Filters* area.

*12.* Now click on the *Sub Query* tab to setup the sub query fields.
{column}
{column:width=70%}
!05master.png|thumbnail,border=1!
{column}
{section}
{section}
{column:width=30%}
*13.* Select the *Athlete ID* field in the *Master Query Filter* to nominate it as the field to be filtered in the Master Query by the Sub Query.

*14.* Select the *Athlete ID* field in the *Link Field* area to nominate it as the field that provides the filter values for the *Master Query Filter*.

*15.* Drag and drop the !rpt_dim.png! *Year* dimension into the *Filters* area.

*16.* You can now click on the !step_right_on.png! at the top of the page to progress to the next step.	 
{column}
{column:width=70%}
!06intersect.png|thumbnail,border=1!
{column}
{section}


h2. Filtering your results
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column:width=30%}
*1.* Now to setup the filters. Click on the !rpt_filterprompt.gif! *Filter Prompt* as before as set the *Master Filter* to *2007*. 

*2.* Your filter should look like this.
{column}
{column:width=70%}
!08masterFilter.png!
{column}
{section}
{section}
{column:width=30%}	 
*3.* Set the *Sub Query Filter* to *2009*. 

*4.* Your second filter should be the same as the one pictured here.	 
{column}
{column:width=70%}
!09intersectFilter.png!
{column}
{section}
{section}
{column:width=30%}
*5.* You can now click on the !step_right_on.png! at the top of the page to view your report.

*6.* You should now have a report that shows you what athletes when on camps in both 2007 *AND* 2009.	
{column}
{column:width=70%}
!10report.png|thumbnail,border=1!
{column}
{section}
{section}
{column:width=30%}
*7.* You are now finished with this report. Click on the *Save Menu*.

*8.* Set the *Name* of your report to *Intersect Sub Query Tutorial*.

*9.* Set the *Description* to *This report was written using the Sub Query Tutorial*.

*10.* Select *Tutorial* as the *Category*.

*11.* Select *Advanced Reporting* as the *Sub Category*.

*12.* Click *Save* to finish.	
{column}
{column:width=70%}
!11activate.png|thumbnail,border=1!
{column}
{section}

bq. See [Filters|Filters] for more information.
\\
\\
{horizontalrule} 
{styleclass: Class=topLink}[top|#top]{styleclass}