More Thoughts on Oracle Hyperion Migration

Eldred Smikle

August 3rd, 2011

A few months and many migrations later, I have thoughts, discoveries, and a two-part question about the Hyperion migration.

Thoughts and Discoveries

I am happy to report that the release documentation continues to impress. And believe me, good documentation goes a long way to making migrations run smoothly.

Another nice surprise in is High Availability. Oracle has made some nice changes from in

In previous versions, High Availability used to be restricted by number of database connections, specifically, Reporting and Analysis had this limitation. This is no longer the case in In the new release you can have multiple database connections for Reporting and Analysis.

The upgrade also allows for true failover. That said, I did encounter one minor problem to note in multiple database connections: The Reporting and Analysis Framework GSM service seemed to improperly register in the Shared Services registry. I am currently working with Oracle support to clarify what is happening. Regardless, while the High Availability function is not quite seamless, the good news is Oracle has definitely brought it a long way, which should make the folks working with the new release very happy.

The Problem Outlined

Before I ask the two-part question, I want to outline the problem:

When doing the prescribed migration it appears that hssmigrate utility omits two key pieces of Shared Services functionality.

Provisioning: Essbase provisioning is something that I fully expected to come over from previous versions. It doesn’t.

Reporting and Analysis: Reporting and Analysis provisioning does not work properly either and currently, the only available workaround is to re-provision all reports manually. This could be quite a bit of work, particularly for companies that work with a large number of reports.

The Essbase and Reports and Analysis provisioning is major and there is no straightforward resolution. We did try testing with LCM (Lifecycle Management) but this is also very time consuming approach.

We are working with Oracle support, but have not been offered a viable solution other than LCM, which we have already discovered is no better than manual.

Two-part Question

The big question is: Have any of you run into this migration problem and if so, have you found a reasonable workaround? If you can answer yes to either part of this question, please drop me a note.  

Last Thoughts

At this juncture, I don’t have any workaround and/or resolutions to offer for these not so minor Provisioning and Reporting and Analysis problems. When I have more information, I’ll post it here.



Eldred Smikle

About Eldred Smikle

Eldred Smikle is the Technical Services Manager for TopDown Consulting. He has over 15 years experience working with Oracle Hyperion Enterprise applications. He specializes in product infrastructure installation and configuration for all Hyperion products. He has worked with a broad base of operating system platforms, relational databases, and Java application servers Microsoft SQL, Oracle, Apache Tomcat, IBM Websphere, BEA Weblogic, and Oracle 10g. A frequent contributor to, Eldred also serves as the publications Oracle Hyperion expert when it comes to reader questions.

4 comments on “More Thoughts on Oracle Hyperion Migration”

  1. Dietmar says:

    thank you very much for these helpful informations. We are currently working on a migration from 9.2.1 to EPM as well (only Essbase and Interactive Reporting). Does it mean, under your point of view, that we have to re-provision all IR-reports on the new server manually?
    One more topic: We are thinking about changing our repository databases from DB2 to Oracle, but the Oracle support couldn’t give us any hints how to manage that. And in short term there is no Oracle/Hyperion consultant available for us. Does anyone have experience with changing the repository from DB2 to Oracle?
    Any suggestions or informations about this topic would be appreciated very much.

  2. Dwana says:

    We have run into the same problem. Did you recieve a response or solution from Oracle?

  3. Michael says:

    We have also run into the provisioning issue in R&A and Essbase. We have a very large number of reports. Have you heard anything regarding a fix from Oracle? Were you able to correct the issue another way?

  4. Robert Singleton says:

    Is anyone aware if these key omissions are fixed?

    We have hundreds of Reports and dashboards that I would rather NOT have to manually reapply security for.


Leave a Reply

Your email address will not be published. Required fields are marked *