BrioQuery - How to Guide

How to Initiate a New Query

1. Click on the BrioQuery icon to start the application and begin a new query.
   To start a new query after closing a previous query, select the File/New option from the menu bar.
2. Begin by selecting the DataModel/Select Open Catalog option from the menu bar.
   The Open Catalog Extension (OCE) panel will then display the pre-defined OCE's available for query.
3. Select the correct OCE, for the database(s) to be used in the query, and click OK.
4. Then, enter the Sybase user ID and password and click OK.
5. Next, select the DataModel/Table Catalog option from the menu bar.
   The Table Catalog panel will be displayed.
6. Select the views(s) to be used in the query and drag them to the Query panel.
   If more than one view is required for the query, drag the field to be joined from the first table ('parent') to the other table ('child') which has the same field to be joined. A connection line will automatically be displayed.
7. Finally, select the fields to be included in the query and drag them to the Request line in the Query panel.
8. If needed, select the fields which require conditional limits in the query and drag them to the Limit line in the Query panel. Then, enter the field selection conditions in the Limit panel and click OK.
9. When all the fields have been included and all the limits defined, press the Process button to execute the query.
10. To view the results of the query, select the Result tab along the bottom of the panel. Also use the Pivot1, Detail1, and Chart1 tabs to format the results into the required pivot table, detail report, and chart.

How to Run an Existing Query

1. Select File/Open from the menu bar.
2. In the Open File panel, make sure that the disk drive and directory path displayed are correctly pointing to where the query file is stored. If not, select the correct drive from the drop down menu and then double click on the sub-directories until they are correct. The query file will be then be displayed in the panel.
3. Select the BrioQuery file (*.bqy) you want to run and click OK.
4. BrioQuery will load the query parameters.
5. Press the Process button to execute the query.
6. You may then view the results, modify the selection criteria, change the sort sequence, add sub-totals, or print the results.

How to Save a Query

1. If you want to save a new query or the changes made to an old query, select File/Save As from the menu bar.
2. In the Save As panel, enter the file name for the new query you are saving.
3. Make sure that the disk drive and directory path displayed are correctly pointing to where you want the query file to be saved. If not, select the correct drive from the drop down menu and then double click on the sub-directories until they are correct.
4. Click OK and the query file will be saved in the directory displayed.

How to Customize an OCE

1. If you need to modify an OCE to include another database, see how to customize an OCE.

Tips and Techniques

BrioQuery - Advanced Features Tour

BrioQuery OCE's

BrioQuery

RETURN TO DATA EXTRACTS - OVERVIEW