Page Comparison

{anchor:top}
{toc: class=contents}
h2. Creating the Intersect Sub Query Introduction
{styleclass: Class=topLink}[top|#top]{styleclass}


h2. Initialise
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* Click on the *Create* link and select *Report* to begin building your report.
{column}
{column: width=70%}
!0101create.png! 
{column}
{section}

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

{column}
{section}

{section}
{column: width=30%}
*3.* Select *Ski Team* as the View.

*4.* Now click
the !step_right_on.png! button to proceed.
{column}
{column: width=70%}
!2a03view.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}
{sectionh2. Master Query
{styleclass: Class=topLink}[top|#top]{styleclass}


h2. Intersect Query
{styleclass: Class=topLink}[top|#top]{styleclass}


h2. Save
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}	

*10x.* 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 fieldsClick *Report* > *Save* to activate your report.
{column}
{column: width=70%}
!05masterxsave.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*13x.* SelectSet the *Athlete IDName* fieldof inyour thereport *Masterto Query Filter* to nominate it as the field to be filtered in the Master Query by the*Intersect Sub Query. 
Tutorial*14.*
Select
the *Athlete ID*x.* fieldSet in the *Link FieldDescription* area to nominate*This itreport aswas thewritten fieldusing that provides the filter values for the *MasterSub Query FilterTutorial*.

*15x.* Drag and drop the !rpt_dim.png!Select *YearTutorial* dimensionas into the *FiltersCategory* area.

*16x.* 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.	 
Select *Training* as the *Sub Category*.

*x.* Click *Activate* to finish.
{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.pngx|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*7x.* You are now finishedhave with this report. Click on the *Save Menu*.

*8.* Set the *Name* of your report to *an active 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%}
!11activatex.png|thumbnail,border=1!
{column}
{section}

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