March 4, 2008

Look Smarter Than You Are With Essbase: An End User's Guide

Tracy McMullen and I co-wrote a book on Essbase almost exactly one year ago. At the time, it was called Essbase for Mere Mortals until our trademark attorney identified some issues with the title which just goes to show you that trademark attorneys are worth every penny. We went through 6 or 7 different titles only to have every single one of them rejected by our trademark attorney on infringement grounds which just goes to show you that trademark attorneys are very frustrating. We finally got approval for the name Look Smarter Than You Are with Hyperion Essbase.

Sales in the first year have been phenomenal. At last check, we were one of the top 25 best selling books of all-time on lulu.com (our publisher) and they publish over 10,000 titles. Normally a computer book has big sales shortly after the release but then sales die down over the lifetime of the book. Our sales last quarter were the biggest yet. Instead of an overnight bestseller, does that make us an overyear bestseller?

Feedback on the book has been mostly positive. People tend to like the humor and the step-by-step approach (as opposed to the more "look up specific stuff" method that the Essbase Database Administrator's Guide follows). My mother complained that the book cost too much, but she was the only one I heard that voiced that concern (Mom's exact quote was, "do I really have to spend $49.95 just to prove I love you?"). The only recurrent complaints were that the index page numbering was slightly off (fixed in the newest release) and that the book was too administrator-oriented to give to, say, an entire finance department.

Frankly, that last criticism was correct. While we built the first third of the book to be geared towards end users, it was immediately followed by a few hundred pages of material about building and administering cubes. While the information wouldn't harm an end user, it seemed silly to make people pay $49.95 for a book and then tell them not to read two-thirds of it. In a fit of (retail) inspiration, Look Smarter Than You Are with Essbase: An End User's Guide was born. It's primarily the same content as the full-blown guide, but with the administrative content removed (and with a new retail price of $29.95 to entice companies to buy in bulk for entire departments).

The book is in the final proofing stages and should be available on our publisher's site by end of March and it'll be on Amazon.com in late April or early May. The point of the book is to give end users of Essbase everything they need to know to slice and dice Essbase cubes from Excel, Word, PowerPoint, or whatever.

The last part of the book to be written was, oddly, chapter one. As readers of our other book
can attest, chapter one is the story that sets the tone for the entire book: this won't be your average, boring computer manual. In my last book, the first chapter was the completely true story of how I blacked out the entire city of New Orleans using only the power of Essbase (or so I thought). I finished chapter one of "An End User's Guide" at three o'clock this morning, so I thought I'd share it with you. It's humorous in a dark, dry sort of way (or at least I think it is after staying up until 3AM writing it). Subject to proofing revisions, here's Chapter One of Look Smarter Than You Are With Essbase: An End User's Guide:

Chapter 1:
How I Almost Killed a Man

In the worst of times, desperate men can be driven to commit acts of desperation. Case in point, I'm sitting in my cubicle at this moment, trying to figure out how to kill my boss with only the power of my thoughts. I've come to the conclusion that it would be much easier to kill him if 1) he was here at the office with me instead of home asleep in his bed; and 2) my brainwaves weren't reduced to brainripples since it's 3AM and budgets are due in six hours. I'll have to abandon the mental murder idea. On to Plan B: how to kill my boss using a luke warm Starbucks venti vanilla latte.

This isn't getting me anywhere. Murder probably isn't appropriate in a business situation and normally I wouldn't attack any of my coworkers with cold, milk-based drinks. How in the name of Odin did I end up like this? As best as my sleep-derived memory can recall, it started with a phone call from my boss, Mr. Deadman. The phone rang; my heart sank.

"Sorry to bother you on such a lovely day," he said. I knew he was looking out his window at the sunset as I stared at my graying, windowless cubicle wall. At least I have a picture of a kitten clinging to a branch with the inspirational quote "Hang on... help is coming" to keep my morale up.

"No, no bother. Any questions on the consolidated budget? They're due tomorrow, so there better not be any questions. You know how I like to leave every day by 5." Since I hadn't left before 6 in this millennium, I laughed at my own semi-joke until I noticed that I was the only one laughing. He didn't say a word.

The silence stretched on like... something that stretches on for a really long time. As I stared at my kitten poster for salvation, he said, "That's actually why I'm calling. I just need you to increase the IT hardware budget by 10%. Rising cost of servers, don't you know? No hurry, because I'm leaving for the day in just a couple of minutes. I won't even be able to look at the revised numbers until morning."

I could feel the anger rising as my morale deflated. I threw a pencil at the stupid kitten picture. Through gritted teeth, I managed to stammer, "Sure... no... problem..." and in my head I continued 'you jerk.'

With the perky voice of someone about to leave at 5:05PM, he said, "excellent, and since it's no problem, can you do me a favor and analyze the IT budget growth since last year? I'd do it myself but I have a doctor's appointment first thing in the morning and I won't be in until right before the budget review meeting."

I imagined that I was the one hanging from that kitten's little tree branch. He took my moment of wondering in entirely the wrong way. "Oh, don't worry, it's nothing serious. It's just a routine check up but I figured I'd do it before year end when things are going to get really hectic. Well, have a great one. Don't work too hard."

He chuckled as he hung up the phone. Yes, he actually chuckled. I ripped the kitten poster off the wall and got to work.

Updating the IT budget itself wasn't what took forever: it was consolidating all of our spreadsheets together. With over 200 Excel spreadsheets, I have to open up each one off the network share drive in exactly the right order, press F9, and then on to the next worksheet.

I ran into a frustrating situation around 11PM. After the initial submission of the budget sheets, someone had opened up his sheet and decided that things would be a bit prettier with one fewer column, so he deleted it. My summary workbook, of course, wasn't smart enough to pick up on this change, so my formulas were adding in the wrong column. I noticed around 11, but it took me until 3AM to find the problem and correct it.

Now we're back to where our story began. Budgets have been consolidated, all errant formulas have been corrected, and I haven't even started on the analysis my boss requested. It's at this point that I realize that there's virtually no way to kill someone with a latte (even a really tasty and worth every dollar Starbucks latte) so I'd need find a better plan. My eyes search my cubicle for implements of destruction.

My eyes wander past my red Swingline stapler and to my monitor where Excel is staring at me: mercilessly mocking me with its unnaturally straight gridlines. The numbers seem to be running across the screen and that's when I realize that I really need to take a nap. Wait. What is this menu item I see between Window and Help? Is this some form of salvation in the form of Essbase or is it just a mirage in the desert that is my existence?

Choirs begin to sing as I realize that the key to my getting a few hours of sleep lies in the hands of a little Excel add-in and its good friend, Essbase. No, they aren't real choirs but rather my iPod playing Beethoven's Ninth, but surely this must be a sign. Remembering everything I learned in that best-selling Essbase book I read, I raced to the Essbase menu and within minutes had resubmitted my budgets, consolidated them, and performed some pretty amazing analysis. I finished everything just in time to sing along with Ode to Joy in gleeful gibberish German.

I must have fallen asleep, because the next thing I knew, my boss was standing at the entrance to my cubicle wearing golf attire. Doctor's appointment, my ass. He spoke as I wiped the drool from the corner of my mouth.

"Wow, that outfit looks great on you. It looks even better on you today than it did yesterday. Say, what happened to your cat poster?"

It was balled up in my trash can at the moment, but I knew just where he should stuff it. I started to suggest it when he said, "I got the analysis you sent me at 4AM. I don't know how you got it done in time. It was wonderful."

Clearing thoughts of relocating my poster into one of his orifices from my head, I managed to eke out, "thank you?"

He smiled and put his hand warmly on my shoulder. I didn't immediately try to break his wrist which meant that my thoughts of death by mind/coffee were gone only to be replaced (momentarily) with thoughts of a sexual harassment lawsuit.

"While I'd love to take the credit, Mr. Deadman, I have to say that I couldn't have done it without Essbase. It saved my life last night" and yours to, I didn't add out loud.

He smiled from sunburned ear to sunburned ear. "Well, I always knew that buying Essbase was a good idea. I guess this proves it. You owe me one!"

He skipped off as I grabbed my copy of Look Smarter Than You Are with Essbase: An End User's Guide and threw it at his head.

Note that the authors of this book do not condone in any way killing people with your thoughts, your venti latte, or your copy of this book. While the story above is false, similar situations occur all the time. We hope that you learn from this book so that you don't do something you might regret after 5-10 years of hard labor. Don't wait until 3AM to recall your Essbase teachings. Read this book, learn how to use Essbase to your advantage, and please, get a good night's sleep.

February 7, 2008

Oracle OpenWorld vs. Collaborate vs. Kaleidoscope

In response to my blog entry on February 6th, Robert posed an interesting question:

If you could only go to one conference (and pretend that you don't get an iPod at any of them :) ), which would you go to? ODTUG, COLLABORATE, or OpenWorld?

First of all, the iPod comment is in response to a post I made during OpenWorld. For being such a decent guy, Oracle decided to reward me with the coolest device ever created (well, as of today), an iPod Touch. Okay, it was a blatant bribe which I shamelessly accepted. I didn't let it cloud my coverage of OpenWorld, though. Most people agree that I was pretty negative on OpenWorld with the exception of my iTouch). [Editor's Note: the iPod Touch is the coolest device ever created, so take that wheel, cotton gin, and telephone.] My problem is that I keep comparing it to the late, great Hyperion Solutions conference. While Hyperion Solutions wasn't as great as the old Arbor Dimension conferences, it was far better than most software conferences.

I seriously doubt Collaborate or Kaleidoscope will be giving me another iTouch, so let's go with Robert's hypothetical and pretend that OpenWorld doesn't give out bribes either. Now which one would I attend if I could only go to one?

Collaborate. Without reservation. If I'm going to a conference, it's primarily to learn. As such, content is key.

I actually got asked a very similar question on Network 54's Essbase discussion board just yesterday (apparently, it's a popular question these days). To parrot what I said there, OpenWorld was very, very marketing-oriented. 80% of the fewer than 100 presentations in the Hyperion track were delivered by Oracle (in some cases, with clients/partners as co-speakers). COLLABORATE is supposed to have 100-150 presentations with 100+ of those delivered by clients and partners.

In the interest of full-disclosure, my company, interRel, is paying to be a 4-star partner of COLLABORATE. Why? Because we're hoping that COLLABORATE becomes the successor to to the Solutions conference.
Solutions was a great opportunity to learn (partying was always secondary) and I refuse to believe it's dead with nothing to take it's mantle. We're investing a great deal of money with the assumption that something has to take the place of Hyperion Solutions conference, and it certainly isn't OpenWorld.

Is OpenWorld completely bad? Absolutely not. In addition to the great bribes, it's a much larger conference than COLLABORATE or ODTUG's Kaleidoscope, so if your thing is networking, by all means, go to OpenWorld. OpenWorld is the best place to get the official Oracle party line on upcoming releases and what not. OpenWorld is also the place to hear better keynotes (well, at least by More Famous People like Larry Ellison, himself). OpenWorld has better parties too. OpenWorld is also in San Francisco which is just a generally cooler town. In short, OpenWorld was very well organized, but since it's being put on by Oracle, it's about them getting out their message to their existing and prospective client base.

So why aren't I recommending Kaleidoscope (since I haven't been to that either)? Size, mostly. Their entire conference will have around 100 presentations, so their Hyperion track will most likely be fewer than 10 presentations. I've been to regional Hyperion User Group meetings that have more than that (well, the one interRel hosted in August of 2007 had 9, but close enough). While Kaleidoscope may one day grow their Hyperion track, it's going to be a long time until they equal the 100-150 presentations that COLLABORATE is supposed to have on Hyperion alone.

If you're only going to one Hyperion-oriented conference this year, register for COLLABORATE. If you've got money in the budget for two conferences, also go to OpenWorld. If you're a developer that finds both COLLABORATE and OpenWorld to be too much high-level fluff, then go to Kaleidoscope.

February 6, 2008

Oracle Conferences - ODTUG

In the good ole days of Hyperion, there was a single annual conference (at least in the USA) each year: Hyperion Solutions. There were also some regional user groups. Now that Oracle has taken over, I can't seem to keep track of all the conferences. There's OpenWorld in the fall (September 21-25 in 2008) which is put on by Oracle and is basically Oracle marketing Oracle. COLLABORATE is held in April (this year is April 13-17 in Denver) and it's put on by the various large Oracle User Group umbrella organizations (IOUG, OAUG, and Quest). At the moment, COLLABORATE seems to be the closest to taking on the banner of the late, great Hyperion Solutions conferences. I just found out this morning about another Oracle conference that's adding Hyperion content: Oracle Development Tools User Group's Kaleidoscope. Their upcoming conference is in June in New Orleans.

I was going to write a really long, extremely poetic blog entry about how to find out more information about ODTUG, but my good friend, Tim Tow, already blogged about it on Monday. Rather than have me repeat the links in his entry, I'll just direct you to Tim's blog. Tim's name is probably familiar to many of you: like me, he's been around the Hyperion world since the dinosaur days of Essbase. He's the founder of AppliedOLAP and he's probably the most active helper on all the Essbase forums around the web. I recommend that everyone bookmark his blog, because he does a great job of sharing technical information.

If you're interested in submitting a paper to the ODTUG Kaleidoscope conference, the deadline has been extended to February 18.

December 15, 2007

Iowa Hyperion User Group

I'm currently freezing in the arctic tundra euphemistically referred to as "Des Moines, Iowa in mid-December." Des Moines just went through an ice storm. While ice storms are very sad and tragic (people die), I have to admit that ice storms make for gorgeous scenery. All the trees look like they've been dipped in glass.

I flew into Des Moines last night from Dallas (via Austin and Chicago). The temperature this morning was 12 degrees: I checked the weather in the USA Today, and it's colder right now in Des Moines than it is in Anchorage, Alaska. How stupid am I? Instead of a thick winter parka, I brought a polyester hoodie. Polyester hoodies are for staying warm during light summer breezes not The Great Ice Storm of Ought Seven.

So why am I in Des Moines on the 14th of December? I'm one of the two presenters at the Iowa Hyperion User Group. The keynote presenter (question: why am I never the keynote?) is John O'Rourke who's one of the Senior Directors of Hyperion at Oracle. He was at Hyperion for years and on a good note, made the jump to Oracle.

There are about forty people here (mostly clients, hurrah) which is impressive considering most people are surprised when they find out there's an Iowa Hyperion User Group at all. Every one of these people seems to be dressed more warmly than I am. Apparently, every one of these people is smarter than I am.

John O'Rourke's presentation is on the Hyperion Roadmap going forward. John acknowledged that the roadmap he's presenting is virtually identical to what was presented at OpenWorld. Interestingly, John isn't actually here in person. He's back East and his flight to Des Moines (via St. Louis) was cancelled. As such, he's doing the keynote via webcast. It's funny to me to think that I traveled to Iowa to watch a webcast. The audio is actually fairly high quality and the slides are coming across well. He started off by taking a poll of how many people in the room went to OpenWorld. About ten people raised their hands which, of course, John couldn't see. Giggle.

The start of his presentation covered the same overall "where does Hyperion fit into Oracle" information that we've all seen before. One thing I'm not sure I've written about before is that Oracle's new official policy is that Essbase is not a database. This is surprising considering that for the last 15 years, everyone has said that Essbase is a database. The problem is that Oracle officially only has one database (the main Oracle relational database). So what is Essbase? It's not clear, but in the EPM diagram, it's part of the Business Intelligence Foundation. I've heard it referred as a server that delivers multi-dimensional data, so I guess it's a "Multi-dimensional server?" I'll have to get my head around that one.

Oracle has three milestones for product integration with Hyperion. The first milestone is "Align and Certify" which was already in the 9.3.1 release. One of the great things that Oracle did in 9.3.1 was to remove the license server. They also did rebranding (putting the Oracle name everywhere) as part of the Align & Certify initiative. The only thing they haven't done yet is to localize Hyperion to the tons of languages that

The second milestone is "Unify & Integrate" which is due in the first and second quarters in 2008 (most likely in the Kennedy/9.5 release of Hyperion). Some of the goals of this milestone are:

- Common user interface & workspace

- Common identity management

- Common application server

- Common data integration

- Common data access & search

- Interoperability across BI foundation

- Integrated access to applications

The third milestone is "Extend & Evolve." This will bring together the Hyperion applications with some of the other Oracle products like Retek, Siebel, Oracle ERP, and so forth.

John talked about some of the goals for what they're now calling "Financial Performance Management" (Planning, HFM, Strategic Finance, etc.). One of their goals for these products is to actually increase the integration with SAP R/3 and SAP BW. This is not unexpected, but it's nice to see it in print. John also announced that the intention is to migrate users of other Oracle products (like Oracle Financial Analyzer, PeopleSoft EPM or Oracle consolidations) to the superior Hyperion products. For example, those using PeopleSoft EPM should be migrating to Hyperion Planning. They're not going to insist on it, but it's clear that future development of budgeting functionality, for instance, will be focused on Hyperion Planning. Likewise, financial consolidation will be concentrated on the Hyperion Financial Management product. Tony (Hyperion's Iowa Account Manager who's the only one in the room, from what I can tell, from Oracle) said that the migration will be a credit towards Hyperion (not a one-for-one replacement) and also pointed out that there's not a migration path. In other words, it's a reinstallation because there's no tool to migrate say, Oracle Financial Analyzer to Essbase (or HFM).

Specific goals for HFM in 9.5 and beyond include:

- 64-bit platform support

- EPM Architect enhancements

o Common calc manager (integrated with Hyperion Planning)

o Lifecycle management

- Reporting accelerator

- Delegated user management and administration

- Better Oracle platform integration including drill-back to the underlying transactional systems

Goals for Hyperion Planning in 2008 include:

- EPM Architect enhancements (same as HFM)

o Common calc manager (integrated with Hyperion Planning)

o Lifecycle management

- Planning for banking

- Delegated user management and administration

- Oracle platform integration

John talked about some of the goals for Hyperion Strategic Finance which include integration with Smart View as well as integration with Hyperion's Crystal Ball acquisition for predictive analysis. Performance Scorecard will also be integrated with Smart View.

The new Hyperion Profitability Application got mentioned again. As many have already heard, it lets a user analyze profitability (hence the catchy name) with support for cost management, activity based costing, traceability maps, and more). One thing I learned about it that I didn't know before is that the primary data store for this application is Essbase. It's currently in beta and should be released in the spring of 2008. It looks a lot like Hyperion Planning and since it uses Essbase, you can access the data with Web Analysis, Financial Reporting, and so forth.

There were a few slides on the future of Essbase which was covered in more detail at OpenWorld. John concluded with a call for people to attend COLLABORATE 2008 in April, 2008. He feels that there will be 80-100 presentations (down from the 150 previously hoped for) with 1/3 of those being delivered from Oracle and the rest from customers and partners. He also mentioned that COLLABORATE is extending a discount to Hyperion clients in the hopes of getting 1,000+ people to the conference; the price should be about $975 per person.

Someone asked about the future of Hyperion Enterprise. Per Tony, Oracle's direction is to push people to HFM. Hyperion Enterprise is going to be continued to be supported and enhanced, though, including Smart View against Enterprise in 2008.

I'm actually giving two presentations (live an in-person, unlike my snowed in buddy, John O'Rourke). One is a repeat of one I've delivered a lot in 2007, "Busting System 9 Migration Myths," which is basically an episode of Mythbusters but with all the myths being Hyperion System 9 specific. It's a lot of fun and includes video clips from the TV show. Normally, I deliver it with my fellow Mythbuster, Eduardo Quiroz (who's also the co-founder of interRel), but today, I'm flying solo since Eduardo recognized that the presentation was in Des Moines in December. My second presentation is on "Best Practices in Reporting & Analysis."

I just delivered my two presentations (with a break in the middle so I could wake up the sleeping attendees). If anyone wants a copy, send an e-mail to info@interrel.com and specify which presentation you want. Pioneer Hi-Bred (a division of DuPont) is hosting this event and they've brought lunch in. I'm going to go hunt down some vegetarian food (oh, the irony), network a bit, and then head to the airport for the flight back to Dallas.

This may end up being my last blog entry for the year, because I don't think I have anything interesting planned for the remainder of 2007. May your 2008 be better than your 2007!

December 11, 2007

Hyperion Town Hall - Houston

I'm at the Alden Hotel in Houston, Texas today attending an Oracle sponsored event called "Hyperion Town Hall."  Basically, they're supposed to talk about the Oracle acquisition of Hyperion.  Here's the agenda:

- Welcome

- Integration Strategy & Roadmap

- Customer Speaker (University of Texas Medical Branch at Galveston)

- Question and Answer

- Networking Session

There is some networking time before the agenda above.  From what I can tell, most of the crowd is either Oracle (former Hyperion) or partners.  Every partner has at least two people (we have three including me).  Having a one-to-one ratio of partners and clients makes for some odd networking situations.  There's a lot of partners talking to partners about partnering.  Observing the forced niceties is making giggle on the inside.

                "Hi, My Dreaded Competition.  What's a nice guy like you doing in a place like this?"

                "Well as I live and breathe, if isn't That Guy I Hate With A Passion!  How the heck have you been?  Hope you haven't lost your arms in a trash compactor accident!"

                "No, of course not, I made sure to stand way back as I pushed your mother in.  I'm kidding of course."

                "Oh, you always were the quick wit.  Well, I guess I better move on and talk to someone with a personality, um, I mean the potential to get me revenue."

                "I completely understand: you're not getting any younger, you know."

The main speaker was Ken Hohenstein, RVP of Southern EPM (over John Hernandez who's the regional EPM manager over Texas, Oklahoma, Louisiana, and Arkansas).  I get along pretty well with Ken on a personal level, but he can be kind of a dry presenter (though that may be due to the dryness of the material too).  He could crack a joke once in a while.

Most of the presentation was pretty dry: the same slides I've seen before.  There's an interesting point on retention post-acquisition: 98% of the development staff joined Oracle and 95% of sales, support, and consulting made the move as well.  I'm thrilled about the development retention.  Consulting?  Not so much.

He talked some about the leadership of the EPM/BI Leadership.  John Kopcke is now SVP of Performance Management and Business Intelligence.  Rich Clayton is now VP of BI and Performance Management Marketing.   Both of those guys are in Product Strategy.  Robert Gersten is in Product Development as SVP of Development of Performance Management and BI.  I think they just said that he's now in charge of 2,000 developers.  Wow.

Ken talked about support for a bit.  One of the more surprising things is that all standard-level and Enterprise-level support clients have been migrated (at apparently, no charge) to Oracle Premier Support on December 1, 2007.  This means that if a Hyperion client was on standard support (meaning only 8 hours per day support, 5 days per week).

One of Mr. Hohenstein's final slides was on the conferences replacing Hyperion Solutions (may she rest in peace).  COLLABORATE 2008 is in Denver from April 13-17.  This is the one put on by the user groups.  They're trying to get more Hyperion presentations at COLLABORATE, and I think it should have 50-100 Hyperion presentations.  OpenWorld 2008 is September 21-25th.  God, I hope they improve the Hyperion content, but I guess I've written about that one to death.

Jay White, President of the South Texas Hyperion User's Group (STxHUG), got up to speak next.  He thanked Oracle for picking up his valet parking and US-Analytics for bribing people (or as Jay put it "donating the door prizes").  He spoke for about 15 minutes, but none is much relevant to those outside of Houston, so I won't repeat it.  At the conclusion of his section, he did comment on interRel's "Hyperion Solutions Road Trip to the South" we held back in August.  He praised our game show (as he put it "Business Intelligence Jeopardy") and said that we must have more money than Oracle to put that event on.  I thought that was pretty darned funny.

The next speaker was Rich Clayton, VP of stuff (see above), talking about the EPM Product Strategy and Roadmap.  He started off by mentioning that Smart View is being placed on top of Hyperion Enterprise which is interesting, because I thought that Enterprise wasn't long for this world.  I'm still not convinced it's staying around, but this is at least a sign that it's not dead already.

Rich had a lot of slides that again, I've seen before on the growth in reporting, analytics, and such.  I'd blog them, but I'm worried that while typing in the content of the slides, I might bore myself into a coma.  Some of the content (specifically around Essbase) was the same as the Future of Essbase presentation from OpenWorld.  Here's what's new:

·         HFM will have enhanced XBRL support.  HFM will also allow journals and adjustments to go back into the underlying ERP (too cool).

·         Financial Reporting will allow annotations to be added to a report.  This could be quite helpful for variance analysis ("you missed your budget: explain yourself, man!").

·         Hyperion will be linked to Oracle E-Business Suite to allow drill-down and account analysis to underlying ERP data (in PeopleSoft, Oracle financial ledgers, etc.) via Hyperion Financial Data Quality Management. 

·         Planning will have a new module to do "Strategic Operational Planning."  I think that means more detail-oriented planning beyond the financial space (like manufacturing detail).

·         Hyperion Profitability Management is being released sometime in 2008.  I haven't seen a demo of this, so I don't know much more beyond the title.  It's apparently going to let a user look at a Profit & Loss statement and have visibility to where all the numbers came from (which were direct and which were allocated).  When I actually see this one live, I'll write more on it.

·         Calculation Manager is the integrated method for writing calculations across all Hyperion products.  It should be in 9.5, but he admits that it will take 2 or 3 releases to get all the kinks worked out.

·         Simplified installation and configuration should be coming in 9.5 (formerly known as Kennedy).

·         Lifecycle Management Services in 9.5 allows administrators to move Hyperion applications from development to production.  It's a retooling of the old Hyperion Hub product, from what I can tell.

·         There are about 75 new features in 9.5 in the old BI+ products (Interactive Reporting, Web Analysis, Financial Reporting, SQR Production Reporting).   The only one that I was able to read (in 3 point font) was that Interactive Reporting in 9.5 will have prettier charts.

·         Visual Explorer will have predictive visualization sometime in 2008.

He said that 9.5 is scheduled for release in May of 2008.  Well, that's targeted, but officially it's sometime in 2008.  Knowing what I know about the beta schedule for 9.5, I think that May-June of 2008 is realistic.

The chairs they have us sitting in are horrible.  I may take a Blog Break so I don't get deep vein thrombosis.  I lost feeling in my legs about an hour ago…

The customer presentation from Jerry Jackson of UTMB (Univ. Texas Medical Branch) was about how they converted an Essbase cube from block storage to aggregate storage.  Considering how marketing-oriented the earlier material was, the technical nature of this presentation was jarring.  Also, the speaker's microphone was set at zero, so no one could hear him.  I was in the back row, so not could I not hear him: I was too far away to read lips.  I did read his slides.  One slide I did enjoy the title of said "18 Dimensions is Not Enough" which explained why they needed to expand from 18 to 24 dimensions to do their financial reporting.  I find this shocking since the dimensionality on financial reporting cubes tends to be much smaller (in the 5-9 dimension range).

Jerry's presentation wasn't nearly as, um, technical as the second presentation from one of the IT people at UTMB.  The topic was "Accessing Stored Procedures [in Oracle] Using Interactive Reporting."  I found the looks on the sales people comical when he started showing stored procedure code.

At the conclusion of the event was some drawing of door prizes.  I may be mistaken, but I think all three prizes were won by employees of UTMB.  This is not surprising since UTMB brought the largest contingent (I guess, because they were speaking?).

I am supposed to go to the Hyperion Town Hall in Dallas tomorrow.  Based on the assumption that tomorrow's content will be quite similar to today's, I think I'm going to skip it.