Tips and Tricks

  • Customizing Brio

    • After Brio is installed on your workstation, you may wish to further customize Brio by following the information below:

  • Installation

  • Oracle Error Messages

    • Repository Catalog Error

      • This message is primarily caused by older queries created in versions prior to Brio 5.5.6. If you get this error message you need to do the following:

Repository Error

        1. SELECT Yes

        2. A copy will be made of the file.

        3. Locate the copy. It should be located in the same location as the original file and should be named, “copyofxxxxx.bqy” (i.e. copyofhighdollr.bqy).

        4. Open the copy file and SAVE.

    • Invalid Column Name:  Oracle Error 904
      • The Oracle Error Message 904, Invalid Column name can be caused by:

Error 904 - Invalid Column Name


    1. The table from which you are pulling a field from is not “open” in the Datamodel section (NOTE: this should only be a problem until we convert everyone).
      You should double-click on every field in your request line to see what table the field is coming from. Then you need to look and see if the table is “open”. If not, you will need to click on the Datamodel section and double-click on the tables that need to be “opened”.

    2. There are computed fields in your request line that don’t have spaces around the calculations. It is likely that this query is a standard or shared query. If so, you can get a copy of the corrected query at either:

Win3/swap/brioquery/standard OR Win3/swap/showcase/shared/

Purdue University, 610 Purdue Mall, West Lafayette, IN 47907, (765) 494-4600

© 2017 Purdue University | An equal access/equal opportunity university | Copyright Complaints | Maintained by ETD Web

Trouble with this page? Disability-related accessibility issue? Please contact Office of ETD at etdweb@purdue.edu.