IR Studio is a module of Oracle Business Intelligence Suite Enterprise Edition Plus that provides business users with intuitive user-directed relational query capabilities for reporting and analysis to produce charts, pivot tables, reports, and more.

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.

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
   • Driver Installation Walkthrough/ODBC Settings (pdf)     Updated: 12/12/2011
   • 32-bit IBM DB2 Data Server Runtime Client (9.7 Fix Pack 4) (44.6 MB)
     
   
   
3. Install Interactive Reporting Studio Software - "IR Studio" Current Version 11.1.2.1
   
   • IR Studio Installation Walkthrough (pdf)     Updated: 05/10/2012
     
     
   Windows 64-bit Installation Files
   
   1. SystemInstaller-11121-amd64.zip (257 MB)
   2. FoundationServices-11121-amd64-Part1.zip (1.01 GB)
   3. FoundationServices-11121-amd64-Part2.zip (1.22 GB)
   4. FoundationServices-11121-amd64-Part3.zip (1.08 GB)
   5. FoundationServices-11121-amd64-Part4.zip (1.39 GB)
   6. FoundationServices-11121-Part5.zip (1.70 GB)
   7. FoundationServices-11121-Part6.zip (48.9 MB)
   8. FoundationServices-11121-Part7.zip (1.01 GB)
   9. InteractiveReporting-11121-part1.zip (308 MB)
   10. InteractiveReporting-11121-amd64-part2.zip (152 MB)
   11. RandAFoundation-11121.zip (136 MB)
   12. StaticContent-11121.zip (1.38 GB)
   
   Windows 32-bit Installation Files
   1. SystemInstaller-11121-win32.zip (216 MB)
   2. FoundationServices-11121-win32-Part1.zip (852 MB)
   3. FoundationServices-11121-win32-Part2.zip (1.23 GB)
   4. FoundationServices-11121-win32-Part3.zip (1.14 GB)
   5. FoundationServices-11121-win32-Part4.zip (1.39 GB)
   6. FoundationServices-11121-Part5.zip (1.70 GB)
   7. FoundationServices-11121-Part6.zip (48.9 MB)
   8. FoundationServices-11121-Part7.zip (1.01 GB)
   9. InteractiveReporting-11121-part1.zip (308 MB)
   10. InteractiveReporting-11121-win32-part2.zip (152 MB)
   11. RandAFoundation-11121.zip (136 MB)
   12. StaticContent-11121.zip (1.38 GB)
   
   
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
     
     Column Order OCE's
     When using these "Column Order" OCE's, the table columns will automatically be in alphabetical order.
     
   • SFMA_ColumnOrder.OCE (6 KB)     Posted: 02/12/2013
   • OSPA_ColumnOrder.OCE (6 KB)     Posted: 02/26/2013
   • SFMA&OSPA_ColumnOrder.OCE (6 KB)     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

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.

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.

• IR Studio vs. Legacy Brio/Hyperion Software Comparison (pdf)
• IR Studio User's Guide (pdf) -- Oracle's Complete Guide to IR Studio (Release 11.1.2)
• Datamart User Maintenance Site- Go here to change your password, request your account be reset, view your current queries or stop a query
• How to create an OCE file (pdf)     Updated: 12/15/2011

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 Administrator
155 Cottage Street NE, U50
Salem, OR 97301-3969
Phone: 503-373-0255
E-mail: Datamart Support