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.