Data and Reporting Services - BrioQuery Guide
Overview
BrioQuery is the report generator used at MIT by most Data Warehouse users to report on information from the warehouse. BrioQuery is made up of five different sections:
- query - where the query is built
- results - where results are displayed after processing
- pivot - which can present data in a spreadsheet style format
- chart - which permits you to view data in line, bar, pie, and other types of graphical charts
- report - a formatted report with more flexible layout options than the Pivot.
All sections except the Query section can be printed or exported for use with other applications.
BrioQuery is a desktop application that can run on your desktop, through Citrix or within a VM. It works with Oracle, which is the application that communicates with the warehouse server. Oracle provides a secure network connection and encryption to protect your data.
Data Warehouse users may wish to refer to our glossary to get definitions for new or unfamiliar terms.
Resources
- Install BrioQuery - Installation instructions.
- [Using BrioQuery 6 via Citrix on Mac OS X machines] - Mac OS X users should install Citrix, a PC emulator enabling you to run PC versions of MIT's enterprise applications that do not have native OS X versions.
- Customize BrioQuery - Once BrioQuery is installed, you can customize it to meet your needs.
- How do I know whether I have a Data Warehouse account?
- Request Access to the Data Warehouse - Before using BrioQuery, be sure you have access.
- Change Your Warehouse Password - Use secure Web certificates to change your password.
- Learn How to Use BrioQuery - Attend an IS&T training course.
- How to Create a Basic Query - Step by step instructions to get you going.
- Creating Advanced Queries - Information for advanced users.
- Getting Results - What to do when things go wrong.
- Downloading and Processing BrioQuery Reports
- Tips on Using BrioQuery
- BrioQuery Parenthesis button
- Configure BrioQuery to prompt for criteria each time
BrioQuery and Excel
- [archive:Import an Excel spreadsheet into BrioQuery report]
- Export Data from BrioQuery into Excel
- Send BrioQuery file with no results attached
Printing
- [hd:Printing options for BrioQuery via Citrix]
Oracle
- Oracle 11gR2 Client for Windows - Installation Instructions
- Oracle 11g Troubleshooting
- Manual Oracle 11gR2 Installation
Oracle Error Messages
- SQLNet not successfully loaded BrioQuery error message
- "TNS could not resolve connect identifier specified", "...could not resolve service name"
- ORA-12545 Connect failed because target host or object does not exist, BrioQuery login error
- ORA-28000 Account is locked error message on MITSIS, Roles DB or BrioQuery login
- Login Failed Error for a BrioQuery Dashboard Report - how to retrieve the underlying error message