Show and share technology design bits and bobs

Bringing Technology Solutions to Small Businesses

How to Install Interactive Reporting 11

Don’t be dismayed by the rumor mill!  The Brio technology – gobbled up by Hyperion in 2003 and evolved into Hyperion Interactive Reporting before being assimilated into the Oracle hive in 2007 – is alive and kicking within the Oracle Business Intelligence Enterprise Edition (OBIEE) suite.

While I am not sure where the wide-spread rumor began,  I can certainly understand why it continues to be propagated.  Oracle’s seemingly illogical technique of burying information about Hyperion Interactive Reporting in the deepest recesses of its site does suggest that IR is on the chopping block.  Couple that with how impossible the Interactive Reporting Studio installation has become for a business user to hack through, and I don’t see the rumors calming down anytime soon.  Since the release of 11 (formally 9.5),  the process for locating, downloading, and installing the Hyperion Interactive Reporting Studio has become so confusing, it makes me feel self-conscious and inadequate every time I have to do it.  Considering how many times I have done this (a gazillion),  the difficulty is concerning.


Contrary to the signs, though, Oracle’s official statement is that Hyperion Interactive Reporting will continue to play a strong role in Oracle’s future BI offerings.   While this is a huge relief to me, it is also an enormous relief to the countless public and private organizations who use Interactive Reporting in their day-to-day business operations.

Hello? Anybody there?

Finding information on Interactive Reporting within any of Oracle’s sites is so painful, I’d suspect the people responsible like to make sadistic scavenger hunts where Interactive Reporting is placed on the list right next to the 25-lb. ball of dryer lint and a penny struck in 1492.   Finding Interactive Reporting information and documentation these days is a serious challenge, so enjoy the quick links below.

What Now?

Treasure Map

You can color while waiting for the files to download.

Surprisingly, Oracle’s search works much better than it used to.  The phrases ‘Interactive Reporting download‘ and ‘Foundation Services download‘ will get you to the files you need to download and install Interactive Reporting  Studio.

Don’t know which files to ones to download? Not surprising, especially if you are a business user who is intimidated about downloading server components you don’t need and which would sap the resources of your computer if you were to accidentally install them.  Anyone who installed the studio client prior to version 11 remembers that it used to be a single .exe file that you would download and run.  Now, thanks to the partial homogenization of Hyperion 11 into the Oracle cluster, 6 zip files are needed.   To boot, you’d better have 11.5 gigs of space free to download and extract them (!).  The specific files to be downloaded are:

Now what?

Either Oracle has yet to document how to install the Hyperion Interactive Reporting Studio for business users, or it has yet put the document somewhere that someone could find.  The void for Studio installation documentation has been neglected for so long that when ”how to install interactive reporting 11” is searched in Google, the highest ranking site is currently a post I made to IT Toolbox in February of 2009 asking for help.  Perhaps it is just me who doesn’t find the installation process intuitive, but I hope that’s  not the case.  Regardless,  below are instructions on how to install Interactive Reporting 11.1.1.3.

  1. Create a new folder in the C: directory of your computer. It can be named anything as long as it does not have any spaces.
  2. Extract all 6 files into the newly created folder.
  3. Double click installTool-auto.  Windows will likely prompt that the file could be dangerous and yadda yadda, but select Run to continue.
  4. A command prompt will open and the scripts will check that all prerequisites have been met before launching the installer.  A few times I have run into errors here, but both were related to spaces within the directory structure of the extracted files.  If you cannot overcome any encountered errors, open the installTool-debug file to get more information about them.
  5. When prompted by the Hyperion EPM System Installer Release 11.1.1.3 to select a language, do so.
  6. Welcome:  This screen isn’t really a welcome, it is legal mumbo jumbo. Click Next.
    Hyperion EPM Interactive Reporting Installation Welcome Screen
  7. Destination: Select a Hyperion home.  The default is C:Hyperion and there typically isn’t a reason to change this.  Click Next.
  8. Installation Type:  By default, the installation type ‘New Installation‘ and ’Choose components by tier‘ are selected.  Change ”Choose components by tier‘ to ‘Choose components individually‘ and then click Next.
  9. Product Selection: By default, there are checkboxes next to Foundation and Interactive Reporting.  Expand the Interactive Reporting components and uncheck Interactive Reporting Services.  This will also uncheck the box next to Foundation.  Click Next.
    Hyperion EPM Interactive Reporting Installation Product Selection Screen
  10. Confirmation: This screen should show ‘Install‘ under the column ‘Install Type‘ for only Interactive Reporting Development Studio Client and Interactive Reporting Studio Client.  Click Next.
    Hyperion EPM Interactive Reporting Installation Confirmation Screen
  11. Progress: This screen shows the progress of the installation of the two components.  The ‘Status‘ column will show “Completed” for other products during the initialization phase of the download.  This does not mean those products are installed – only the Interactive Reporting Dashboard Development Studio Client and the Interactive Reporting Studio Client will actually be installed.
    Hyperion EPM Interactive Reporting Installation Progress Screen
  12. Summary:  Hopefully everything went well! Since no server components were installed that need to be configured, click Finish to close the installer.
    Hyperion EPM Interactive Reporting Installation Summary Screen

To access the software, find it in the Programs folder of the Start menu under Oracle EPM System.

Post Script

The first time I attempted to access the sample database installed automatically with Interactive Reporting, I was so frustrated over pawing through documentation to find the user name and password that I was beside myself.  As it turns out, there is no user name or password for the sample.oce  – just click OK when prompted.

About the Author

Emily VoseWhile Emily comes from a fine arts background, she made her mark on the world as a enterprise Business Intelligence Expert. After publishing the only expert guide on the market for Oracle's Hyperion Interactive Reporting, she decided to take on a new challenge. Nodding back to her fine arts background, she combined that with the business process management sense and project management skills she picked up working for large commercial customers and government agencies. She then set out to start a full-service tech firm to help small business get the tech they need to be successful and Wagger Designs was born.View all posts by Emily Vose →

  1. denu samson
    denu samson09-07-2011

    Thankyou so much.
    I have been trying to install these files or get any useful information on these for a while now.
    This is much appreciated.

  2. Chainsaw
    Chainsaw10-24-2011

    Awesome! Clear, concise and very helpful!

  3. analyst
    analyst04-16-2012

    thanks a lot for posting this, it is indeed a challenge to get this information together and make sense of this. Saved me a lot of work ! thx !

  4. John
    John06-18-2012

    Is shared services required on a new install, or will security, etc. work with just interactive reporting…

    Thanks so much for this…it was a big help

    • Emily Vose
      Emily Vose06-18-2012

      Hi John,

      This post discusses how to install the Interactive Reporting Studio client, which can be used as a completely standalone tool. As it is installed as an application on the individual’s client machine, it does not require interaction with Shared Services or any other Hyperion and EPM server components. The only security that may be enforced is at the data level – such as with a database.

      If you would like security enforced from Shared Services, utilize the web plugin client. The web plugin is essentially a browser extension that gives users most of the functionality found in the Studio client but through Internet Explorer. The Studio client is typically downloaded automatically when a report is opened in web plugin mode (as opposed to HTML mode) from Workspace.

      I hope this helps & thank you for your question! – Emily

  5. John
    John06-19-2012

    thanks…do you have any tips if I need to install the server version of IR and shared services in order to have my users access the web reporting feature?

    • Emily Vose
      Emily Vose06-19-2012

      The installation of Foundation Services (of which Shared Services is a component), the Reporting and Analysis Framework (RAF), Interactive Reporting Services, and the required shared components can be a harrowing experience if you have not performed a server install of any EPM components in the past.

      In very general terms, a few tips:

      1. Don’t forget to install your database clients and make sure the repository databases are accessible from the component servers
      2. Make sure you have the proper ports open
      3. Provision Shared Services at the Group level & give users their own directories within Workspace
      4. Work from a detailed infrastructure plan — don’t wing it

      I’d recommend engaging a consultant to plan the infrastructure and then perform the installation – especially for the production environment. If you are interested in purchasing consulting time to help you plan and/or perform an installation of Interactive reporting from us, feel free to email me to discuss further.

      Good Luck! -Emily

  6. Yim
    Yim11-05-2012

    Hello Emily:

    According to your installation, there is 1 file for the Interactive Reporting download. However, there are 3 Interactive Reporting Downloads in the download site : http://www.oracle.com/technetwork/middleware/epm/downloads/interactive-reporting-1112x-1584986.html

    Which one to download? (EPM System Release 11.1.2.2.0 Part 7, EPM System Relaease 11.1.2..2.0 Oracle HTTP Server, Translation Workbench?)

    I was a BRIO developer and Admin for a number of years. Now, it is so confusing getting back to it. BRIO supposed to be a intuitive tool.

    Thanks, Yim

    • Wouter
      Wouter12-10-2012

      Yim / Emily,

      I’m facing the same issue with the latest version (11.1.2.2.0) available on Oracle’s website.
      I can run the installer and can install IR but not without having to install some foundation services. I’m unable to uncheck them and they do get installed. Could you explain how to get the IR client without any addition services? It would be much appreciated.

      Thanks

      Wouter

      • Emily Vose
        Emily Vose01-26-2013

        Yim & Wouter,

        Greetings to both of you; sorry for the long delay in response. Your posts got lost a large sea of spam that hit us over the holiday season and we’ve taken steps to ensure this doesn’t happen in the future.

        Are you still having issues?

        Yim, the components you are referencing are required only for the server installation of Hyperion Interactive Reporting within the EPM architecture and are unnecessary for the IR client.

        If you are, in fact, seeking only the IR Client, I believe the steps I outlined above to still be accurate (although I haven’t installed it since 8/12 so please let me know if they are out of date).

        Wouter, To avoid installing any foundation products, be sure that you un-select all of them when you are in the EPM system installer. By default, it will try to install the base foundation package so just be sure that you select only the two IR client options but not the IR Services.

        Cheers!

Leave a Reply

Captcha Garb (1.5)