Page Comparison

{anchor:top}
{toc: class=contents}
h2. 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%}
!01create.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%}
!02builderType.png!
{column}
{section}

{section}
{column: width=30%}
*3.* Select *Ski Team* as the View.
{column}
{column: width=70%}
!03view.png|thumbnail,border=1!
{column}
{section}

h2. Master Query
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*x.* Drag and drop the !rpt_dim.png! *Athlete ID*, !rpt_dim.png! *First Name*, !rpt_dim.png! *Last Name*, and !rpt_dim.png! *Date of Birth* dimensions into the *Columns* list.

*x.* Drag and drop the !rpt_dim.png! *Year* dimension into the *Filters* list.
{column}
{column: width=70%}
!04master.png|thumbnail,border=1! 
{column}
{section}


h2. Minus Query
{styleclass: Class=topLink}[top|#top]{styleclass}
h3. Create Minus
{section}
{column: width=30%}
*11.* Click on the *+* button in the Sub Query panel to the left of the Data step to add a Sub Query.

*12.* Set the Type to *Minus* and Style to *Basic*.

*13.* Click *Ok* to set up the query.
{column}
{column: width=70%}
!05addMinus.png|thumbnail,border=1!
{column}
{section}

h3. Configure Minus
{section}
{column: width=30%}
*28.* Set the *Filter* on the *Master Query* to apply to the *Athlete ID* field. This is how rows to be removed from the master query will be located, matching the ID field.

*29.* Set the *Exclude* field on the *Sub Query* to be the *Athlete ID* field. This will list all Athete ID values to be removed from the master query.

*30.* Drag the *Year* field into the *Sub Query Filters* list. This will be used to restrict the list of Athlete IDs to remove to a certain date range.

*31.* Change the name of the Sub Query to *Prior Years* and the description to *Remove all customers from previous years to create a list of new customers for the current year.*

*x.* Click *Save* to complete the *Minus*.
{column}
{column: width=70%}
!06configureMinus.png|thumbnail,border=1!
{column}
{section}

h3. Edit Settings
{section}
{column: width=30%}
*32.* If you need to make changes to your sub query setup at all, click the *Edit Settings* link.
{column}
{column: width=70%}
!10settings.png!
{column}
{section}


h2. Apply Filters
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*18.* Click on the *Settings* link in the *Filters* panel. This will allow you to configure logic and values for both filters.
{column}
{column: width=70%}
!07filterSettings.png!
{column}
{section}

h3. Master Filter
{section}
{column: width=30%}
*19.* Set the *Master Query* filter to be Year *Between* 

*20.* Click the *Define Value* link and select the *Pre-defined Period* option.

*21.* Select the *This Calendar Year* option and click the *Submit* button.
{column}
{column: width=70%}
!08masterFilter.png|thumbnail,border=1!
{column}
{section}

h3. Sub Query Filter
{section}
{column: width=30%}
*21.* Navigate to the sub query filter by clicking on the *Prior Years* tab.

*x.* Set the filter to be Year *Less than or equal to* 

*x.* Click the *Define Value* link and select the *Pre-defined Period* option.

*x.* Select the *Calendar Year Start* option and click the *Submit* button.

*x.* Close the Configure Filters panel.
{column}
{column: width=70%}
!15appendValue.png|thumbnail,border=1!
{column}
{section}

h2. Save
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*x.* Click *Report* > *Save* to activate your report.
{column}
{column: width=70%}
!xsave.png!
{column}
{section}
{section}
{column: width=30%}
*x.* Set the *Name* of your report to *Minus Sub Query Tutorial*.

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

*x.* Select *Tutorial* as the *Category*.

*x.* Select *Training* as the *Sub Category*.

*x.* Click *Activate* to finish.
{column}
{column: width=70%}
!x|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*x.* You now have an active Minus Sub Query report.
{column}
{column: width=70%}
!x.png!
{column}
{section}

\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}