Downloading and Processing BrioQuery Reports

Instructions for Macintosh

Downloading Reports

1. From the list of reports on the web page, find the one you want to download and click on the Mac link underneath the report name. Citrix users should download the PC version.
   
   
2. If an error message appears about an "octet-stream" file, click Save As.
   
   
3. Click on the Save File button.
   Result: The report name icon appears on your desktop.
   
   
4. Open BrioQuery. From the File menu, select Open.
   Result: A list of files appears.
   
   
5. Double click the report you want.
   Result: The query displaying the appropriate tables appears on the screen.
   
   
6. Mac OS X users still using BrioQuery under Classic rather than via Citrix: If you cannot see or open the report you just downloaded, you need to take some additional steps to convert it:
   1. Control-click on the downloaded file icon.
   2. Choose Get Info from the pop-up box.
   3. In the next pop-up box, under Open with (toward the bottom), choose Other.
   4. In the Choose Other Application box, choose All Applications instead of the default "recommended applications" for the Enable option.
   5. In the next drop down, choose BrioQuery 6.2.3.
   6. The BrioQuery application in the applications list box will now be activated instead of grayed out. Double-click on it.
   7. The box from Step 3 will reappear, and "Open with" should now show BrioQuery. Close this box.
   8. When you double-click on the downloaded report icon, it should open in BrioQuery.
      
      
7. After you have opened and processed your query, select File>Save As, and then click the Save button.
   
   
8. When the Replace question appears, click on the Replace button. The report is now on your desktop saved as a BrioQuery file. From now on, to open this report, just double-click on it. BrioQuery will automatically open and display the query for the report.

Processing Reports

1. If not already open, double click on the report icon.
   Result: The report opens the Query section.
   
   
2. To run the report, press the Process button at the top of your screen.
   Result: You will be prompted to log on to the Warehouse. If needed, select the OCE (open catalog extension) as warehse.oce. You will need to enter your username and Warehouse password.
   
   
3. Depending on the report, you may be prompted to enter a limit. In the window that appears a short text message is displayed to assist you with your limit selection.
   
   
4. Once results are retrieved you will be automatically viewing the Results section. You will see many rows of information. This is your raw (unformatted) data. The pre-formatted reports are in other section as explained next.
   
   
5. Proceed to the other sections to view the pre-formatted results. They are listed in the Sections area on the left side of the window. The report sections will be named with a meaningful description for that report. You now can print the report, or export it to Microsoft Excel.

[Back to top]

Instructions for Windows PCs

Downloading Reports - Internet Explorer

1. From the list of reports on the web page, find the one you want to download and right-click on the PC link underneath the report name.
   
   
2. Choose to Save Target As...
   Result: The Save As screen appears.
   
   
3. In the Save In box at the top, navigate to the folder in which you want to save the file, or save it to your Desktop. Make sure the "save as type" is either "BrioQuery Document" or "All Files".
   
   
4. Click the Save button.
   Result: The report name icon appears on your desktop, or in the folder to which you downloaded it.

Downloading Reports - Netscape

1. From the list of reports on the web page, find the one you want to download and click on the PC link underneath the report name.
   
   
2. Choose Save this file to Disk.
   Result: The Save As screen appears. Make sure the "save as type" is "bqy".
   
   
3. Change the directory folder from Netscape to Desktop or the desired folder, if necessary.
   
   
4. Click on the Save button.
   Result: The report name icon appears on your desktop.

Note for Netscape users: If when you click on the PC link under the report name, a text file opens rather than the dialog box, you need to edit your browser preferences and identify BrioQuery as a Netscape helper application. To do this:

1. Go to Netscape Edit Menu > Preferences > Navigator > Downloads.
   
   
2. Select Open the download manager in the Downloads Dialog box if it is not already selected.
   
   
3. While still in the Navigator section of Netscape Preferences, choose Helper Applications.
   
   
4. Click New.
   
   
5. In the New Type dialog box, for Description of type, enter BrioQuery.
   
   
6. For File extension, enter bqy (do not put the dot, .bqy, just bqy).
   
   
7. For MIME type enter application/x-brio.
   
   
8. For Application to use, navigate to the BrioQuery application in the BrioQuery program folder in your PC Programs folder. Enclose the navigation path in quotation marks.

Processing Reports

1. Go directly to the desktop and double click on the report you want.
   Result: BrioQuery will automatically open the report. The report opens on the Query section.
   
   
2. To run the report, press the Process button at the top of your screen.
   Result: You will be prompted to log on to the warehouse. If needed, select the OCE (open catalog extension) as warehse.oce. You will need to enter your username and Warehouse password.
   
   
3. Depending on the report, you may be prompted to enter a limit. In the window that appears a short text message is displayed to assist you with your limit selection.
   
   
4. Once results are retrieved you will be automatically viewing the Results section. You will see many rows of information. This is your raw (unformatted) data. The pre-formatted reports are in other sections as explained next.
   
   
5. Proceed to the other sections to view the pre-formatted results. They are listed in the Sections area on the left side of the window. The report sections will be named with a meaningful description for that report. You now can print the report, or export it to Microsoft Excel.

[Back to top]