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

Interactive Reporting is an extremely robust and powerful business intelligence tool providing ad-hoc querying, data analysis, dashboards, and other reporting capabilities to produce charts, pivot tables, reports, and more. IR Studio is a module of Oracle Business Intelligence Suite Enterprise Edition Plus.

The Department of Administrative Services (DAS), Datamart Team maintains an enterprise license for the State of Oregon that entitles all state agency personnel to install IR Studio for accessing the Datamart. (This has been in place since June 2010.)

IMPORTANT NOTE!   Although individual users may download the files independently, we highly recommend that users coordinate with their local IT support personnel.

32-bit vs. 64-bit

  • IR Studio is only available as a 32-bit application.
  • IR Studio can only use 32-bit ODBC connections.
    The 64-bit installation files differ only in how it installs under Windows 7 and the updated security functions.
    The same 32-bit application is installed.


Complete Datamart User Setup Process

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.
    Columns will be in alphabetical order.
    • SFMA Datamart OCE (6 KB)     Updated: 02/12/2013
    • OSPA Datamart OCE (6 KB)     Updated: 02/26/2013
    • SFMA & OSPA Datamart OCE (6 KB) Combined     Posted: 02/26/2013

      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 Information
Interactive Reporting Logo

IR Studio has been certified for Windows XP and Windows 7 (32-bit and 64-bit) installations.

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.

It is recommended, but not required, to 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

Vacant
155 Cottage Street NE, U50
Salem, OR 97301-3969
Phone: 503-373-0255
E-mail: Datamart Support