Datamart Enterprise Query Tool Software
Oracle Hyperion Interactive Reporting Studio (IR Studio)
Oracle EPM Logo

The business intelligence toolset originally developed by Brio Technologies has been a very popular product. Through the years, the product name has changed several times (BrioQuery, Brio Intelligence, Hyperion Intelligence, and now "IR Studio") but the product has remained fundamentally the same.

IR Studio is a module of Oracle Business Intelligence Suite Enterprise Edition Plus that provides business users with intuitive user-directed relational query capabilities and complex data modeling for full ad hoc access to source data. IR Studio can pull together data from different sources to produce easy to use charts, pivot tables, highly formatted reports, and more.

Effective June 1, 2010, Department of Administrative Services (DAS), State Controller's Division (SCD), Statewide Accounting and Reporting Services (SARS) purchased an enterprise license for the State of Oregon that entitles all state agency personnel to install IR Studio for accessing the Datamart.

IMPORTANT NOTE!  Although individual users may download the files independently, we highly recommend that users coordinate with their local IT support personnel.  In many instances, we believe the IT support unit will choose to develop an agency-wide rollout plan.


Complete Datamart User Setup


To access the Datamart:

  1. Request authorization/login by submitting a Datamart Standard View Access Request through your Agency Security Officer

  2. Install IBM DB2 Driver and Create ODBC Connection
  3. Install Interactive Reporting Studio Software - "IR Studio" Current Version 11.1.2.1
  4. Download/Save OCE file -- Required to connect IR Studio to the ODBC connection.
    • SFMA Datamart OCE (6 KB)     Updated: 11/29/2011
    • OSPA Datamart OCE (6 KB)     Updated: 11/29/2011
    • SFMA & OSPA Datamart OCE (6 KB) Combined     Posted: 04/23/2011
      Default directory for saving OCE files in version 11.1.2.1:
        C:\Oracle\Middleware\EPMSystem11R1\products\biplus\data\Open Catalog Extensions
Application Updates and Patches

Error Message Not Found

If you are receiving the error "Error message not found", please download an updated OCE file or modify your current OCE files to check the "Disable asynchronous processing" box.

Version 11.1.2.1 posted on November 9, 2011 contains the latest security updates and enhancements, including a fix for the dashboard "bscript" errors.


Current Brio/Hyperion Users
Interactive Reporting Logo

State agency personnel currently using legacy versions of Brio/Hyperion can download and install IR Studio. The current release is version 11.1.2.1 and has been certified for Windows XP and Windows 7.

Agencies can continue to use their existing IBM DB2 driver, ODBC connections, and OCE files. It is recommended, but not required, that agencies uninstall earlier unsupported versions of Brio/Hyperion software.


Additional Links

Contact Information

Aaron Wallace, Senior Datamart Business Analyst
155 Cottage Street NE, U50
Salem, OR 97301-3969
Phone: 503-373-0269
E-mail: Datamart Support

Tonya Harbison, Senior Systems Analyst
155 Cottage Street NE, U50
Salem, OR 97301-3969
Phone: 503-373-0255
E-mail: Datamart Support