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):

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.

July 10, 2008

For those of you who like to plan well in advance, ODTUG's Kaleidoscope conference will be held June 21-25, 2009 in Monterey, California at the Hyatt Regency Monterey Resort and Spa. The Hyperion track next year will be several times larger than this year (while doing their best to maintain the same level of quality as this year) so my advice is to make your hotel reservations now.

July 2, 2008

A lot of people have been asking me for more details on the new Profitability Management application that sits on top of Essbase. It's been demoed for months now, but all the demos are very light on specifics. Thankfully, Jennifer Toomey from Oracle has put together a "statement of direction" for what they're calling "Hyperion Profitability and Cost Management, Fusion Edition."