July 12, 2008

EPM 11x - Generally Available

After months of development, testing, and delays, it looks like "Oracle EPM System, Fusion Edition" (also known as EPM 11x or Hyperion 11.1) has officially been delivered:
http://edelivery.oracle.com/
First of all, unlike all prior Hyperion releases, you don't select "Hyperion Performance Management and BI" as the product pack. There's a new product pack for "Oracle Enterprise Performance Management System." Once you select this, there are two platforms available. Both are for Windows: the only difference is in 32-bit vs. 64-bit. The other platforms should be out towards the end of this quarter and possibly not until Q4.

According to the eDelivery site, the full 32-bit media pack is ~11 Gb and contains 29 parts (64-bit media pack is 17 parts and 7.3 Gb) . Hyperion 9.3.1 was 57 parts making up 14 Gb. Anyone have any idea how they added more features, more products, and somehow shrunk the download size? All I can think of is that it's because it's only English, and the download will grow once they add the localized versions to the mix.

The Read Me's (and Installation documents) are only 33 Mb. I encourage everyone to download part #V-13499 just to learn more about the new 11x features. It's amazing what you stumble across in Read Me files. For instance, I just now discovered that Strategic Finance is missing along with all the integrated Crystal Ball functionality. The Read Me says that for Strategic Finance, you should "see 9.3.1 media pack" which I guess means that there isn't a Strategic Finance 11.1.1.0.0 at the moment.

I haven't had time to read all of the Read Me files. I opened the Essbase one first. There are 3 1/2 pages of Known Issues with Essbase 11.1.1.0.0. Some of them are kinda surprising to me. For instance, the MDX Parent function has this problem (yes, this is an exact quote):
Running the MDX Parent function does not return the member's parent.
Well, on the one hand, I guess I'm glad someone noticed. On the other hand, what the hell does this function do if not to return the Parent? This known issue is also kinda fun (it's an issue between the Spreadsheet Add-In and Windows Vista):
Launching Query Designer from Spreadsheet Add-in causes Excel to terminate abnormally.

I guess we'll either not use Vista or just tell our users not to click on Query Designer.

That said, there are hundreds of positive features and bug fixes in "Oracle EPM System, Fusion Edition" (rolls right off the tongue, doesn't it?). For instance, here are the bullets from the 16 page New Features in Essbase 11.1.1.0.0. Read Me. Each one of these items summarizes paragraphs of new features and this is just Essbase:
  • Installation and configuration
  • Lifecycle management
  • Typed measures
  • Format strings
  • Varying attributes
  • Strategy for backing up and restoring BSO databases
  • Methods for clearing data from specific regions of ASO databases
  • Environment variables used in the calculation scripts and formulas of BSO databases
  • Optimization of the replication of ASO databases
  • Grid expansion during queries of transparent partitions
  • Log transaction response times from transparent partition target
  • Grid size limits for ASO transparent partition target
  • Batch insertion as data is exported to relational databases
  • Unicode support for ASO
  • Common logging
  • Implied share override
  • XOLAP
  • Performing multiple SQL data loads in parallel to ASO
  • Calculation functions (13 new functions)
  • MDX functions (12 new functions, 1 new clause, 1 new directive)
  • Report writer commands (7 new commands)
  • Essbase.CFG configuration settings (12 new settings)
  • MaxL statements (11 new statements)
  • API Functions and structures (60 new functions and types)
And Essbase isn't the only product with a boatload of new functionality. The Planning new features PDF is 12 pages long. HFM has 8 pages of new features. Performance Scorecard has 16 pages of new stuff. Hyperion Reporting & Analysis (what they used to call "BI+) has 16 pages. Smart View has 8. Even Shared Services has a couple of pages of new features. This is definitely the most important Hyperion-wide update in this millennium (far more relevant than the helpful to the planet than the release Hyperion System 9).

If you are going to upgrade your development environment to 11.1.1, here are the current supported paths:
  • 9.2.0.3 to 11.1.1
  • 9.2.1 to 11.1.1
  • 9.3.x to 11.1.1
Per the documentation, if you're on an earlier version, you must go to one of these three versions first, and then upgrade from there. Now to point out the blatantly obvious, please don't use any of the new 11x products in production YET. Wait for a patch or two (or three or...) to come out before you spring this on your end users. In the mean time, download and install EPM 11x, and then come back here to discuss your findings. If you're crazy enough to install this new version in anything other than a very limited development environment, may God have mercy on your soul.

7 comments:

Bronson Elliott said...

I figure we'll be doing good just to get to System 9. I can't even get my company to get me someone to help out with Essbase functions/development.

How soon until the Essbase 11 book comes out?

Edward Roske said...

Good call waiting on 11x (even though it's because you're not getting a lot of help, it's still a good call).

As for the Essbase 11 book, it should be around the end of the year. I don't want anyone thinking that me issuing an update to the book means I tacitly approve of anyone trying to use it in production. ;)

srx said...

Oracle Essbase Server Release 11.1.1.0.0 = 1.7G ???...
What da hell was packed with it the whole Noa's arch or what??
Another great idea to pack all module together...

Edward Roske said...

From what I can tell, they've included:
- Essbase Server
- Administration Services
- Integration Services
- Essbase Studio

And probably provider services, Application Builder.NET, and everything else Essbase-related besides.

I wish I knew definitively, but I'm still trying to download the 1.7Gb server download. The download progress bar estimates I have around 2 hours to go, but it's been downloading for 2 days already, so I'm a bit skeptical...

Edward Roske said...

The download finally finished. It's pretty much what I predicted in my last comment. Strangely, the install for provider services is a gigabyte by itself. I really wish these were available as separate downloads, because I'm not exactly in the mood to install provider services right now. Ah, well.

Raj said...

Dear Ed, We are a $1Bn+ company. We are planning to migrate to system 9.3.1 from 7.1.3. However, system 11 (or Fusion) has started to spread a scare in my management board. Is there a chance that Oracle/Hyperion will ask us to de-support System 9 and ask us (read force us) to migrate to this newer version (Fusion) starting the second day after going on to System 9.3.1.

Please advise.

Edward Roske said...

Raj, you're safe on System 9.3.1 until at least 2012 according to Oracle's Lifetime Support Policy. That said, I'd strongly consider waiting until January and then going straight to 11x assuming they've patched it by then.

While Oracle won't force you (for a long time, at least) to go to 11x, keep in mind that since 11x is out, 9.3.1 is already an obsolete product. Who wants to upgrade to a product that's already out-of-date?