BrioQuery Landing Page

On this page:

Overview

BrioQuery is the query tool most often used at MIT to retrieve data from the Data Warehouse.

Key Features

• Store and run multiple queries in one file.
• Access queries from different databases.
• Remove duplicate data.
• Create reports.
• Display and print data in tables.

How to Obtain

To download BrioQuery, visit the IS&T BrioQuery page.

How to Use

• Data and Reporting Services - Downloading and Processing BrioQuery Reports
• Data and Reporting Services - Tips on Using BrioQuery
• Data and Reporting Services - Using BrioQuery via Citrix Receiver on Mac OS X
• Getting started with running BrioQuery reports against the Data Warehouse

Troubleshooting and FAQ's

Functions and Usage

• BrioQuery on 32-bit or 64-bit Windows 10 and newer
• BrioQuery Parenthesis button
• Can I search on substrings in BrioQuery limits?
• Configure BrioQuery to prompt for criteria each time
• Create a Basic Query in BrioQuery
• Creating Advanced Queries
• Customize BrioQuery on Your Desktop
• Download a BrioQuery Report to Excel
• Getting Results You Expect
• How Do I Rename a Column Title in a BrioQuery Report?
• How to Run the TIP Management Report
• Launch SQLPlus to test Oracle client connection
• Paste a custom limit string into a BrioQuery report
• Run a BrioQuery report via Citrix - step by step instructions
• Run the FRC BrioQuery report for fiscal periods prior to those displayed in the list
• Send BrioQuery file with no results attached
• Test whether the Oracle client is successfully installed

Troubleshooting

• Oracle 11gR2 Client for Windows - Installation Instructions
• BrioQuery prompts me for serial number on first launch
• BrioQuery reports from off campus - VPN is required
• Brioquery window is blank
• How do I fix a date problem that occurs when I export a section from BrioQuery to Excel?
• I am trying to run the DLC Directory Invalid Address Report (Dept dir invalid addr.bqy) but when I start processing the report I don't get any Directory Org Unit Name listed
• Login Failed Error for a BrioQuery Dashboard Report - how to retrieve the underlying error message
• ORA-01031 insufficient privileges - BrioQuery error message
• ORA-12660 Encryption or crypto-checksumming parameters incompatible
• SQLNet not successfully loaded BrioQuery error message
• Table or view does not exist error, BrioQuery

See Also

• BrioQuery 6.6 - New Features

Have Questions or Still Need Help?

• Contact the IS&T Service Desk

Additional escalation information for Help Staff can be found here: [hd:BrioQuery Recon] [hd:BrioQuery Reporting - HD Troubleshooting Steps and Escalation process]