Data and Reporting Services - BrioQuery Guide

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.
  • star schemas
  • fact tables
  • dimension tables
  • rules about joins
  • applying limits
  • guidelines for efficient queries

  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

  Related Links

  • Data and Reporting Services
  • Data and Reporting Services: Getting Started