Creating the Intersect Sub Query
[top]
1. Click on the Create link and select Report to begin building your report.
Unable to render embedded object: File (01.png) not found.
2. You should now be on the Initialise Report page. Select the Drag and Drop Builder as the build tool.
Unable to render embedded object: File (02.png) not found.
3. Select Ski Team as the View.
4. Now click the Unable to render embedded object: File (step_right_on.png) not found. button to proceed.
Unable to render embedded object: File (2a.png) not found.
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.
Unable to render embedded object: File (03option.png) not found.
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.
Unable to render embedded object: File (04intersect.png) not found.
10. Drag and drop the 
Athlete ID, First Name, and Last Name dimensions into the Column Fields area.
11. Drag and drop the Year dimension into the Filters area.
12. Now click on the Sub Query tab to setup the sub query fields.
Unable to render embedded object: File (05master.png) not found.
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 Year dimension into the Filters area.
16. You can now click on the Unable to render embedded object: File (step_right_on.png) not found. at the top of the page to progress to the next step.
Unable to render embedded object: File (06intersect.png) not found.
Filtering your results
[top]
1. Now to setup the filters. Click on the Unable to render embedded object: File (rpt_filterprompt.gif) not found. Filter Prompt as before as set the Master Filter to 2007.
2. Your filter should look like this.
3. Set the Sub Query Filter to 2009.
4. Your second filter should be the same as the one pictured here.
5. You can now click on the Unable to render embedded object: File (step_right_on.png) not found. 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.
Unable to render embedded object: File (10report.png) not found.
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.
Unable to render embedded object: File (11activate.png) not found.
See [Filters] for more information.
[top]