AAUDE banner MIT Data Warehouse logo

Instructions for Downloading and Processing Queries from the Web

Mac | PC

For the PC:

Downloading sample queries

From the list of sample queries on the web page, find the one you want to download. Click on:

  • the Brio link to download the query in BrioQuery
  • the SQL link to view/download the SQL script for the query
  • the Access link to download the query in Microsfot Access

For BrioQuery the Save As screen appears after you click on Brio.

  1. Change the directory folder from Netscape to Desktop, if necessary.
  2. Click on the Save button. The query name icon appears on your desktop.

Processing the queries in BrioQuery

  1. Go directly to the desktop and double click on the query you want. BrioQuery will automatically open the query. The query opens on the "Query" section tab. To run the query, press the "Process" button at the top of your screen.
  2. You will be prompted to log on to the warehouse. If needed, select the OCE (open catalog extension) as Aaude_warehouse.oce. You will need to enter your username and warehouse password.
  3. Depending on the query, 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" tab. 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 section tabs to view the pre-formatted results. Use the "VCR" buttons at the bottom left of your screen to navigate to and between sections. The report section tabs will be named with a meaningful description for that report. You now can print the report, or export it to Microsoft Excel.


For the Macintosh:

Downloading sample queries

Click on:

For BrioQuery:

  1. If an error message appears about an "octet-stream" file, click on Save As.
  2. Click on the Save File button, and the query name icon appears on your desktop.
  3. Open BrioQuery.
  4. From the File menu, select Open. A list of files appears.
  5. Double click on the query you want. The query displaying the appropriate tables appears on the screen.
  6. From the File menu, select Save As and click on the Save button.
  7. When the Replace question appears, click on the Replace button. The query is now on your desktop saved as a BrioQuery file. From now on, to open this query, just click on it. BrioQuery will automatically open and display the "Query" section.

Processing queries in BrioQuery

  1. If not already open, double click on the query icon. The opens on the "Query" section tab. To run the query, press the "Process" button at the top of your screen.
  2. You will be prompted to log on to the warehouse. If needed, select the OCE (open catalog extension) as aaude_warehouse.oce. You will need to enter your username and warehouse password.
  3. Depending on the query, 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" tab. 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 section tabs to view the pre-formatted results. Use the "VCR" buttons at the bottom left of your screen to navigate to and between sections. The report section tabs will be named with a meaningful description for that report. You now can print the report, or export it to Microsoft Excel.

Further note for BrioQuery

If you have downloaded a query from the web and are having trouble opening it, try using the "Set to BrioQuery file" action. In your BrioQuery folder, locate the Set to BrioQuery file icon. Make an alias (apple key-M once the icon is highlighted), if you like, to move to your desktop for convenient access. Drag the icon of the query over the Set to BrioQuery file icon. The query icon changes in appearance from a blank sheet to a BrioQuery document icon, along with the message that the document has been converted to a BrioQuery file. You should now be able to double click on the icon to open the query directly.


e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home
last updated: