This is just an opinion I need from you guys.
Currently, there is System 9.3.1 in which only Interactive Reporting is in use. Now, client has decided to migrate from 9.3.1 to 184.108.40.206.
I was just going through Oracle roadmap for IR. I am just confused about future of IR. It seems Oracle is not much enhancing IR in EPM product suite. Rather they are improving IR through OBIEE.
This is a case where client is using only IR from Hyperion product suite & want to migrate the same.
What is better path?
Hyperion 9.3.1 to 220.127.116.11 or Hyperion 931 to OBIEE ?
If its better from 931 to OBIEE, what are high level steps? Also how can we migrate Users, provisioning , reports to OBIEE?
Please correct me if I am going wrong here.
First off, yes, Interactive Reporting is no longer Oracle's Strategic Reporting tool. You can find out more here.
The Statement of Direction
Oracle will support Interactive Reporting version 11.x through various levels of support and you will need to get that from your Sales Person.
From a pure technology perspective you will be better served getting up to 18.104.22.168 due to browser and operating compatibilities with version 9.3.1.
OBIEE is a completely different animal and paradigm from Interactive Reporting. OBIEE uses the Common Enterprise Information Model (CEIM) within a centrally managed RPD that contains the Data Model and all the business logic.
You will find more information, documentation, demos and samples related to OBIEE
I strongly suggest you spend some serious time reviewing how it works from a user, developer and administrator perspective. Converting to OBIEE is not a straight forward conversion. There is a utility that has been provided by Oracle to *aid* in this process but you really need to have someone who is strong in the OBIEE - RPB Modeling. Note that there are parts of a BQY that will flow through the utility and others will not. You will really need to spend some time with the documentation and practicing.
You may also want to look at BIPublisher as an alternate target for your conversion. If your BQYs are primarily just producing paginated reports and little to no dashboards you may find that BIPublisher is a better fit.
Thanks a lot. That was really valuable information.
Do you know any known issues or major post upgrade issues that we might face after upgrade from 9.3.x to 22.214.171.124?
Also, Can you suggest EPM 126.96.36.199 is best fit or 188.8.131.52 (as far as IR is concerned) ?
I believe Oracle has added feature of supporting excel files of .XLSX format from 122, which is good. But not sure on stability of IR in 184.108.40.206.
It comes down to an issue of maintaining compatibility with current software versus having a product that actually works.
I upgraded from 9.3.3 to 220.127.116.11 (On MS Windows Server 2008 R2/SQL Server 2008 R2/Windows 7 64-bit). Here are the changes:
I was testing 18.104.22.168 while planning an upgrade and found:
Recommendation: TEST EXTENSIVELY. Paint a clear picture for management showing that newer isn't necessarily better.