Showing posts with label Solutions. Show all posts
Showing posts with label Solutions. Show all posts

January 23, 2012

Kscope12 - Schedule is Published

Waterpark at the JW Marriott Hill Country
2012 will be my final year as conference chair for the Kscope conference.  In case you haven't heard elsewhere, in 2012, it's June 24-28 in San Antonio, TX at the gorgeous JW Marriott Hill Country.  The schedule has been finalized, published, and (I'll humbly admit this since I really had very little to do with it) it's the best schedule I've seen for a conference in my memory.  Yes, historians, the schedule is better than the last Hyperion Solutions conference because there are no marketing sessions (beyond one timeslot for clearly marked vendor sessions) and the content is deep and not just broad.

It's also not dominated by the software vendor (unlike Solutions).  When the maker of the software speaks (Oracle, in our case), it's because they're asked to speak and on topics we care about.  On the subject of Hyperion, for instance, Oracle is hosting an entire day-long symposium on what's going to be released in the future for Hyperion, Essbase, and OBIEE.  It's led by product development and not the Oracle product marketing guys.

One of the expansion areas this year is that in the areas of BI and EPM, they're adding more business and introductory content.  Here are all the dedicated BI/EPM tracks for Kscope12 amounting to over 150 sessions (click on the name of each to get a page about each track):
- Business Intelligence.  This track is led by some of the best OBIEE (and other Oracle BI product areas) people in the business.  The track has been expanded this year as the importance of BI has grown tremendously within Oracle.
- Essbase.  They have over 50 sessions all on Essbase this year.  This is more than any other conference in the world.  This track will cover intermediate to advanced Essbase sessions you won't get at conferences like Collaborate, Connection Point, or OpenWorld.
- Essbase Beginner.  This is a new track that allows people who are just getting started in the world of Hyperion to get some introductory training from the best in the business.
- Hyperion Applications. Hyperion Planning, HFM (Hyperion Financial Management), Hyperion Strategic Finance, and all the other Hyperion applications finally get a track of their own... and it has over 50 sessions dedicated to the Hyperion applications.  Like the Essbase track, this makes it the largest Hyperion application track of any conference in the world.
- Hyperion Business Content. For the first time in 2012, we are adding a track devoted to the business users.  If you're a director, manager, VP, controller, power user, or any type of person who primarily uses or manages Hyperion/Essbase instead of implementing it, you finally have a place to turn.  Since Solutions ended in 2007, a true Hyperion or EPM business-specific user didn't have dedicated content at any conference.  Collaborate tried (and no offense, failed).  OpenWorld missed dramatically by assuming most users were either CFO's or users with hard-core IT backgrounds.  Business people, welcome to Kscope.

In addition to those 150+ sessions on Business Intelligence and Enterprise Performance Management, there are other tracks serving the non BI/EPM community:

If you haven't registered for the conference yet, I will save you $100.  If you've already registered, it's too late.  When you register, put in promo code IRC (it stands for interRel Consulting) and it'll take $100 off whatever the prevailing rate is.  Consider that my gift for you reading this far in the blog (for which $100 is not nearly enough, I'm sure you're thinking).

February 28, 2011

I'm Totally Lost: Which Conference Do I Go To for Hyperion and Oracle EPM/BI Content?

The final Hyperion Solutions conference (the great big conference Hyperion used to put on with non-stop Hyperion content and over 4,000 attendees) was in the spring of 2007.  Back then, everyone knew which conference to attend, because there was only one national conference (Solutions) and then a whole lot of regional HUG (Hyperion User Group) meetings.  But then Oracle bought Hyperion and immediately disbanded the conference leaving the user community in disarray.


There are now several options depending on what you're looking for.  While I could attempt to make some sense out of the whole conference jumble in a blog post, I decided it would be better explained in a webcast.  To that end, I'm devoting two webcasts this week to the question “Now that the Hyperion Solutions conference is gone, which conference should I attend?”


I'm going to compare the benefits of the better known 2011 conferences:


I'm in a unique position to do this, because I don't work for Oracle and I have some ties to every one of these events (so you could say that while I'm biased, I realize the value each one can bring to the right audience).  Usually, our webcasts are only open to Oracle customers (not partners) but in this case, I want everyone to know why you'd want to go to each of the conferences so they don't find themselves wasting money at a conference that's totally not right for them.


Click on the links below to sign up for either Tuesday or Wednesday's webcast:



I will spend around 45 minutes covering all the conferences and then take questions from the audience.  Before you sign up for one of the conferences, devote 45 minutes of your life to making sure you won't find yourself trapped in the 7th circle of hell (otherwise known as stuck at a conference you hate).

November 15, 2009

Regional EPM Connection Conferences - Update

OAUG Connection Point - Enterprise Performance Management
Back on October 30, I wrote about what little information I had on the upcoming regional OAUG conferences on Hyperion and EPM. The name that OAUG is giving to these conferences is way too long and way too hard to remember, so I'm going to start calling them "EPM Connection" conferences. If OAUG doesn't like it, they should come up with a shorter, catchier, more marketable name (like Dimensions, Solutions, Collaborate, Kaleidoscope, or OpenWorld).

I have some new information to impart compliments of the OAUG eNews from November (scroll way to the bottom):

Date Change: February 22-23
Contrary to earlier information that put the dates slightly later, the conference is now going to be held on Monday and Tuesday (Feb. 22-23) in Jersey City, NJ.

Tracks Revealed
There are going to be 5 tracks at the first EPM Connection conference:
  • Budget, Forecasting & Planning
  • Financial Consolidations & Reporting
  • Business Intelligence & Analytics
  • The Office of the CFO
  • EPM Product Roadmap
The non-product orientation of the tracks seems to imply that this will be more of a business-oriented rather than technical conference. Considering that this is put on by OAUG, we sort of expected that though. To drive this point home, OAUG had this to say about their desired audience:
This event is ideal for accounting and finance professionals of all experience levels, internal audit staff with a focus on external and compliance reporting areas, and IT professionals who need to understand what the accounting and finance groups need to achieve.
I don't like how EPM is getting pigeonholed as only applicable to finance/accounting types, but you can't win 'em all.

More Information
OAUG is telling people that more information will be coming soon to this website:

At the moment, there is less at that link than I just discussed in this blog posting, but I'm sure more will be posted soon since EPM Connection is now just 3 months away. They'd better hurry with their call for papers (if they're even going to have one).

October 28, 2009

Kaleidoscope Speaker Submission Extended to November 10

ODTUG Kaleidoscope is, as mentioned previously, the main national Hyperion/EPM conference for 2010. It will have content for all types of users on Essbase, Hyperion Planning, HFM, the Hyperion & OBIEE reporting tools, and more. There are 4 tracks entirely devoted to Hyperion & Essbase and as this the replacement (at least in 2010) for the old Hyperion Solutions conference, you'll definitely want to be there.

So since you're going, let's get you a free pass if we can. The easiest way to get a pass to K'Scope is to speak at the conference. Though the original deadline was October 27, they've just extended the deadline to November 10. Visit http://odtugkaleidoscope.com/ if you want to submit something by the 10th. The two tracks that could use more submissions are the Essbase and Hardcore Hyperion areas but also feel free to submit more in the Hyperion Applications and Hyperion Reporting Tools tracks as well.

While K'Scope is still looking for the advanced/guru/expert content they've offered in the past, this year they've expanded their tracks to have enough rooms to also have some more introductory and intermediate content. So if you want to present on something at a beginning level like a case study or success story of Hyperion or EPM at your company, please feel free. There will be room for all levels at K'Scope 2010. I hope to see you there even if you're not accepted as a speaker.

October 5, 2009

Hyperion Solutions Conference Returns (in 2 different ways)

Solutions 2.0
The story first broke at Collaborate 2009 in Orlando when Kristin Newman (who's now President of the OAUG Hyperion SIG) announced that talks were underway to resurrect the Solutions conference. Now this meant different things to different people. Some thought of Solutions as the big, annual conference where 4,000+ Hyperion users got together. Others thought of it as a place where users of Hyperion could gather to be educated in-depth about Hyperion. So the question was, what exactly was going to happen in Solutions 2.0?

Turns out, there are two answers.

The National Conference
As I've blogged about before (some would say that I've blogged about it ad nauseum), where there used to be one major gathering in the USA per year, there became at least three post-Oracle acquisition: Oracle OpenWorld, OAUG/IOUG/Quest Collaborate, and ODTUG Kaleidoscope. If you added Hyperion attendance for all three of these conferences in 2008, you got less than a third of the people who made it to the last Solutions. So where did all the people go?

They stayed home. Simply, since no one was quite sure where to go, 3,000+ Hyperion Solutions attendees went... nowhere. Well, the good news is that the dust seems to have settled on these major conferences and we seem to have a winner: ODTUG Kaleidoscope.

Of the three conferences with major Hyperion content, it was the only one to grow its attendance from 2008 to 2009, and it's growing even more next year. Compare that with Collaborate which reduced the number of Hyperion presentations from 2008 to 2009. Further, Collaborate is reducing their presentations on Hyperion even more in 2009 to less than 50 total sessions. OpenWorld will have fewer Hyperion attendees this year than 2007 or 2008 and the trend will probably continue into next year.

In other words, if you want to have a ton of different options spanning the gamut from the introductory Oracle EPM sessions to the hardcore Hyperion presentations, go ahead and make your reservations now for Kaleidoscope. It will be held in Washington, DC from June 27-July 1 at the Marriott Wardman Park Hotel. For more information, visit http://odtugkaleidoscope.com/.

If you want a free pass to Kaleidoscope (and who doesn't with companies as frugal as they are these days), ODTUG is currently looking for presenters for the 2010 conference. Some of the Hyperion (Oracle EPM) categories for which they need speakers include Essbase, Hyperion applications (Planning, HFM, HSF, et al), Hardcore Hyperion, and the OBIEE/Hyperion Reporting Tools. The deadline for submitting abstracts is October 27, so hurry to:

The Regional Conferences
But what about those who can't devote a week of travel to Hyperion? For those users who want 2 days of intense Hyperion content including multiple presentations across multiple themes, theOAUG Hyperion SIG now has an answer for you.

The Hyperion SIG will be putting on a series of regional conferences in in 5 different cities around the USA over the course of 2010. These 2-day events will have 5-7 tracks of content and each track will have 10 or so different sessions in it. As such, users of Hyperion will be able to travel to their region's conference for more than 50 different sessions. For those cutting back on travel in 2010 (or those who only have 2 days to give to the cause of Hyperion and Oracle EPM learning), these conferences are a great option.

They're still trying to iron out the details for 2010, but as the Essbase Domain Lead for OAUG, I've been privy to some advanced briefings. Barring some political snafu, these conferences will definitely be happening. OAUG is finally to the point where they're starting to make the general population aware of these conferences.

OAUG Hyperion SIG Partner Briefing Call: October 9
There will be two introductory calls to brief the partner community on Friday, October 9. The first will be at 8AM Central and the second at 2PM Central. The dial-in number is (219) 509-8020 and the participant code is 154751. That's from an e-mail I received, so if that number doesn't work on the 9th, make sure to visit http://hyperionsig.oaug.org/ to see if they've updated the call-in information.

In case there were any partners who didn't received that e-mail, here's the bulk of it (reprinted with permission from OAUG Hyperion SIG President, Kristin Newman):

Dial-in Number:1-219-509-8020
Participant Access Code:154751

WE ARE EXCITED TO FINALLY ANNOUNCE AND SHARE INFORMATION WITH THE HYPERION AND BI COMMUNITY ABOUT 2010 CONFERENCES!! THIS IS A CALL YOU DON'T WANT TO MISS!!

Agenda:

1. Collaborate 2010 - Information on Hyperion presentations and focus for 2010 - presentation numbers, target audience, etc.

2. Regional Conference Model for 2 day "Solutions" type conferences across the USA for 2010.

This is a unique and innovative opportunity for Partners to be involved on the ground floor up! The OAUG has supported the Hyperion and BI community in supporting the need for Education in the local markets!

This has been in works all year and the Board of Directors of the Hyperion SIG and OBI SIG want to share first hand what we've been advocating for and what is happening.

We will discuss the conference model, sponsorship opportunities, speaking opportunities, tracks, etc.

If you receive this e-mail as a member of either the OAUG Hyperion SIG or OBI SIG, but you think that other decision-makers at your firms should attend, please forward this invite to them. We will hold 2 calls on Friday, October 9th to choose from. Additionally, we will discuss this model at our semi-annual meeting at OOW on Sunday, October 11 at the OAUG Hyperion SIG meeting (1-3pm). After Open World, we will publish this information on our website!

We look forward to sharing information with the Hyperion & BI Partner Community!!!

Kind Regards,
Kristin Newman
President/Coordinator
OAUG Hyperion SIG Board of Directors
E-Mail: hyperionsig(at)gmail.com
214.223.7171

So if you're a partner/vendor interested in presenting or exhibiting at one of the regional Solutions 2.0 conferences, make sure you attend the call on the 9th.

So, to be clear...
If you're looking to go to a national conference in 2010 that comes the closest to what you got out of Solutions, go to ODTUG Kaleidoscope. If you want something more regional in scope (like the Hyperion User Groups of old but on cool, designer steroids), make plans to attend whichver of theOAUG regional conferences in 2010 is closest to you.

So where does that leave Collaborate and OpenWorld? Well, I'd go to OpenWorld or Collaborate if Oracle EPM and Hyperion were not my primary concerns. These conferences will still be there for people looking to find out about multiple products though the EPM content will be noticeably light in 2010 (even more so than it was in 2009).

Personally, I'm breathing a sigh of relief because we finally have a clear answer as to where the Essbase and Hyperion user community will be gathering in 2010. I'm just glad we found out before the budget season closed. Go forth and make your Hyperion conference travel request for 2010.

Where does that leave me?
Not that anyone particularly cares, but I have to go to all of the conferences and that now includes five more regional conferences. An Oracle ACE Director's speaking life is never done.

May 8, 2009

Collaborate - Wrapup

Picture of Collaborate boxed lunch, compliments of Eric Helmer.

My apologies to those who were following throughout each day, but this post will suffice to wrap up the conference for me. In case you're wondering why I decided to stop blogging during each day, it's because nothing interesting was happening.

Boring conference. Good or bad? Discuss.

This must be one of the most boring, underattended conferences I've ever seen. Let's start with the boring part. There's no news to be had at this conference. No one is breaking big stories or making huge press releases. Controversy is sorely absent and no one is announcing major decisions. The most interesting pseudo-news story of the conference was the possible creation of a second Solutions conference, but it's really only an idea right now.

For us bloggers looking for interesting topics, there's little to be had. You can only write about the food not being fit to feed pigs (lest the SPCA get upset about cruelty to animals) before you start to feel you've covered it. Charles Phillips said during his keynote that Oracle will start to make some product announcements at Collaborate, so maybe it'll be better in 2010.

Education level dropping to critical levels, Captain.

There are those who come to conferences to learn and being entertained is low on the priority list. For those, I don't know about the other tracks, but the Hyperion track didn't offer great educational opportunities. The number of total presentations on Hyperion was less than 100 (compared to close to 300 in the Solutions days), so even the presentations that weren't infomercials (and there were some annoyingly bad consulting company infomercials) could only cover so much. The number of Essbase presentations (less than 10?) was sadly pitiful considering the number of Essbase users world-wide is into the millions.

Normally, the interRel presentations can be counted on for some detailed training material, but since there were so many Hyperion products to cover and only a handful of slots allocated to each product, even our presenters were forced to go broad but not deep. [Side note: we did have a number of Hyperion-centric attendees who started just going to interRel presentations. I really think this is cool, by the way. interRel fan club in the making?] Simply put, to provide a solid educational opportunity, they need to have a whole lot more sessions (a la, Hyperion Solutions conferences) or only focus on the key products and go really deep (a la, ODTUG Kaleidoscope conferences).

Where have all the people gone?

This may be the only large conference I've ever attended where no one will go on record with the attendance numbers. I'll give you an example. Here's Ray Payne (who's a decently nice guy, by the way, and if he resurrects Solutions will be my hero) responding to a question fromSearchOracle.com about attendance numbers from Collaborate:

That's actually a good question. We knew that we were going to be down in attendance. I have traveled over the country in the past four months and attended several other events, saw what was happening, and we were planning for it. The good news is that we saw a last-minute up-tick. I don't have the final numbers, but we actually had, from my understanding, a good number of walk-ons. So we were pleasantly surprised.

Well, it's understandable that OAUG doesn't have any numbers, because this interview was completed well before the conference began... oops, correction, it was done on Wednesday, May 6, the last full day of the conference. Apparently they had difficulty counting all the Orlando residents who were walking by the convention center, saw someone was holding a conference, and decided to come in to buy a last minute pass. When they finish counting all these impulse buyers, we should see final numbers. Until then, I'm forced to go on things people have said unofficially as well as my own impressions. If anyone has official numbers, please send them to me and I will immediately update them here, because I don't want to be the source of any bad information.

The number that I heard unofficially was 2,200 attendees from OAUG, and 2,400 from Quest and IOUG put together. This would give us around 4,600 total attendees, but I heard from others that these numbers were inflated, because these aren't necessarily full conference attendees. Apparently, the scuttlebutt around the conference is that these numbers included attendees who only but majorly reduced price single-day conference passes. Someone told me that the reported number of real full conferencegoers was less than 3,500. Now we also have to wonder if that 3,000 number included exhibitor passes and the real number is even lower than that?

Per the FAQ on the Collaborate website (which also humorously states "and we expect more in 2009"), there were 7,500 attendees at Collaborate 2009. Since this year is 4,600 by the most optimistic counts and a lot of people are claiming the 3,000, attendance has obviously plummeted. That's a drop of 40-60% from last year. But could it really be this severe of a decrease? The Hyperion attendance numbers seem to back it up. Let's assume that the presentations at which I spoke are representative of the overall Hyperion track (I had about 8% of the Hyperion presentations). Here are a couple of things I noticed about attendance at my sessions:

  • The ratio of vendors to customers was about 3 to 1. I've never seen a user conference this skewed.
  • Last year, I gave a presentation that filled the room to the point where they had to have me give the presentation again to handle the overflow people who couldn't get in. There were over 200 people there. This year, I gave the same presentation (it got great ratings in '08). Attendance? 25 people.
  • My highest attended presentation was 80 people. Note that I didn't see any other normal Hyperion presentation (skipping the keynote is basically what I mean here) draw this many.
  • While the 80 people was my highest attended presentation on Monday, my highest on Tuesday was 40, and my highest on Wednesday was 25. By the time Thursday rolled around, one of the Hyperion presentations, per the speaker himself, had four people in it.
  • The daily attendance dops were seen by every one of the Hyperion presenters. One of Tim Tow's presentations had 3 attendees.

Supposedly, there were around 1,000 Hyperion attendees at Collaborate 2008. This year, the numbers I heard ranged from 500-600, but I really don't believe there were this many unless you also lump in the BI/DW guys. If the number really was 500-600, though, then this is right in the 40-50% dropoff range that the numbers above reflect.

While I really hope that these numbers are inaccurate, I'd love to hear your opinions on the attendance. Again, if anyone has accurate counts, let me know (or point me to the right press release or source on the web) and I'll update it here immediately.

High points

Lest I seem like a non-stop flow of criticism, there were some things I really liked about this year's conference:

  • Plenty of space to walk around without being bothered! Just kidding, Collaborate board members. I'm sure this is a sore enough point that I will ease up.
  • Better food. Yes, I know I complained about the food earlier on in this very same post, I was mostly talking about the lunches. The evening offerings (Monday's and Tuesday's at the exhibit hall as well as Wednesday at Islands of Adventure) were very, very good. The evening desert offerings were very impressive. While alcoholic drinks weren't free on Wednesday night this year, I frankly prefer that over the rationing ticket method, so kudos there too. The food is definitely quite an improvement over last year, and I will give credit where credit is due. Fix the luncheon fare next year, and I promise to tell the world using as many creative compliments as I previously did snarky criticisms.
  • Rooms were together. While the EPM content in total was spread over 11 rooms all across the massive OCCC, most of the good quality content (i.e., that put together by the OAUG Hyperion SIG) was confined to 3 main rooms. Even better, all three of the rooms were right next to each other. If you ignored the Quest sessions, IOUG sessions, and the couple of scattered OAUG sessions, you could go to all the sessions without walking more than 100 feet between rooms.
  • Better product coverage. Last year, a lot of Hyperion products didn't get a single presentation devoted to them. This year, the good folks on the OAUG Hyperion SIG board made sure that all products got covered. I wish they had more presentations to allot, but they did get a good mix from what they were allowed to do. I know how hard it is to prepare one of these schedules, and my compliments go out to Ed Delise, Kristin Newman, and Doreen Fox-Dwyer.
  • Location, location, location. Sorry, folks in Denver, but I prefer Orlando in May to Denver in April (it snowed one day during last year's Collaborate). I know some people hate when conferences get into rotating between Las Vegas and Orlando annually, but those cities do know how to handle a convention.

In conclusion...

They really did work to make this year's conference better than last year and a lot of those changes seem to be coming from the OAUG leadership. Aside from the fact that no one really got to see them, the improvements were noticeable. I hope that Collaborate continues to get better. The problem is that it may be too late. With half the Hyperion attendees in 2009 of 2008 (and no one from Hyperion really knew about it in 2008), there may be no Hyperion/EPM people left in Las Vegas at Collaborate 2010.

May 3, 2009

Collaborate - Day One

I'm sitting in the OAUG Hyperion SIG meeting. There were somewhere around 50 people in the room (and three-quarters of those appear to be vendors) at the start but more trickled in over the course of the meeting. Attendance is down more than 100 people from last year. This doesn't bode well for the conference as a whole (which I think will be down from 7,000+ last year to less than 5,000 this year). There are lots of reasons for the drop in attendance (Hyperion and otherwise) from 2008, but here are my top 4:
  • Scheduling. Someone at OAUG scheduled Collaborate during the first five working days of the month. To whomever this moron is: this is during month-end close. Over half of the Hyperion users who attend conferences (from the client base, at least) work in finance and accounting. They can't go to a conference during financial close! Yes, I know there's probably a really good reason for this (like this was the only time the conference center was available), but it's a fraking slap in the face to all the Hyperion attendees. OAUG, this one is your fault, so don't be shocked when your Hyperion users can't make it this year.
  • Economy. This one's obvious: it's hard for people to convince their bosses to let them go to Orlando for a week-long conference. OAUG did what they could to reduce costs (including a few different hotel discounts), so I give them credit for trying to get attendance up. One of interRel's clients sent 10 people to Collaborate 2008. This year? They're sending 1. I know of several of our clients who already had paid for their conference fees who have decided not
  • Last Year's Conference. At Collaborate 2008, people were expecting to see that Collab had replaced the old Hyperion Solutions conference. While Solutions 2007 had 4,500 attendees and 275+ presentations. Collaborate 2008 had fewer than 1,000 Hyperion attendees and less than 100 Hyperion presentations. People wanted more content and when the number of presentations actually decreased from 2008 to 2009, the word got out and attendance suffered. Also, as we've documented here before, the logistics last year were horrible and as I've mentioned at length, the food wasn't even good enough to torture prisoners with. Please, tell me OAUG has fixed the logistics and food issues this year, or it may end up being the death of Hyperion attendance at Collaborate.
  • Swine/H1N1 flu. Okay, this one is a little silly, but there are people afraid to fly (Joe Biden, for instance). I've already talked to four people from the UK who have decided not to come because of flu fears. This is just bad timing.
There were about 1,000 Hyperion attendees at Collaborate 2008, but I think they'll be getting less than 600 at this year's conference (with over half of those being vendors). My prediction is that attendance is so far down from last year, that they won't even announce attendance publicly for Hyperion or the conference as a whole. I could be wrong, so if anyone sees an actual attendance announcement, share it with us on this blog.

Join OAUG
A lady (who's name I didn't catch) from OAUG gave a brief "welcome to the conference and you should become a paying member of OAUG" speech that listed less than 3 minutes. While the lady seemed nice enough, I saw Ray Payne, new President of OAUG, in the back of the room, and I really wish he had done the official OAUG portion, because it would have shown OAUG's commitment to the Hyperion SIG. While I know he was there (which did show me his commitment), most of the room didn't know who he was. I think he had a conflicting session right at the start, but I do like that he stopped by our room for a bit.

Ed Delise Opening
Ed Delise is the current president of OAUG Hyperion SIG (though he's stepping down to let someone else run as president). Ed gave a 20 minute discussion about what the Hyperion SIG has done over the last year and what their goals are for 2009. The membership is up to over 600 people, and they're looking for more people to join.

He talked about the elections briefly. I strongly encourage those interested in directing the future of OAUG Hyperion SIG to run for the board. I especially encourage people from the client base to run for board positions: the board right now is way, way, way too partner heavy. The board wants to be less than 50% vendors, and I wholly concur. Click here to find out the open positions (you have until May 6 to nominate yourself):
http://hyperionsig.oaug.org/HLeadership.php?page=Leadership/Volunteering

Hyperion Solutions Returns?
Kristin Newman from interRel announced that OAUG is working to develop an EPM/BI/Hyperion-specific conference separate from Collaborate, OpenWorld, and Kaleidoscope. The proposed logistics put this in November 2009 back in Orlando. I'm amazingly excited to hear this, and I anxiously await more information on this. I first mentioned to Ray Payne that there should be a stand-alone Hyperion conference around 2 years ago, and I'm thrilled as... something really thrilled that they're going to try to put one on.

I'm presuming that the unified conference will include the end user content from Collaborate, the technical training from ODTUG Kaleidoscope, and the Oracle high-level sessions from OpenWorld into one. UPDATE: I talked to Ray Payne at the Hyperion SIG reception, and he did agree that November of this year was a bit aggressive. Whenever it happens (as long as it's in the next 12 months), I'll be there. Follow this blog for further updates on "Solutions 2: Long Live Solutions."

EPM in Troubled Times
Mike Schrader from Oracle (BI & PM Strategic Architecture) gave a presentation on "EPM in Troubled Times." I don't have much to say about this presentation, because it was a bit high-level. If he sends me a copy of the PowerPoint, I'll link to it from here.

I do want to point out that Mike (and a few other guys from Oracle as well as a partner or two) has a book coming out hopefully by the end of the year called Oracle Essbase & Oracle OLAP (catchy name). It supposed to cover using Essbase as well as Oracle OLAP from, judging by the chapter names, a business use case standpoint. I know several of the authors and I respect their expertise. I don't know how good those authors are at writing, but technically, they're very competent, so I encourage you to consider buying the book when it comes out (after you've bought one of our Essbase books, of course ;-).

At the end of Mike's presentation there was a hilarious (to me) discussion of "what the heck does EPM really mean?" Someone asked Mike for his definition of EPM, and he said "It's going beyond operational excellence to management excellence" and the room went dead silent. I was cracking up on the inside. After Mike's presentation, there was a 15-minute break to let people stretch their legs, network, and drink. After the break, the room had dropped to 40 people. I'm not sure where the rest went?

Domain Leads
Each of the 5-6 domain leads for Hyperion SIG got to spend 5 minutes telling about new developments in their individual areas of expertise. Hearing long-winded people (myself definitely included) limit themselves to 5 minutes was high hilarity. Tim Tow from Applied OLAP was kind enough to give me his 5 minutes, so I got to talk for 10 minutes on Essbase 11x, and I finished with just 24 seconds to spare.

Roundtable Discussion
Ed Delise fielded roundtable questions from the audience for several minutes until the questions started getting pointless. I personally don't like these just because they can turn into "and here's this obscure bug I ran into: has anyone else heard of it?" sessions. Ed fielded the questions really well, but I didn't derive any value from it.

SIG Reception
After the SIG, I'm heading to a reception that interRel is co-sponsoring at BB King's next door to the conference. It lasts from 6:30-8:30 and then I'm headed back to the hotel, because I agreed to do a presentation on Essbase Studio at 8AM tomorrow morning (proving that I also am a moron).

I'll be here all week
I will, shockingly, be blogging all week about Collaborate. If you want to follow my Collaborate blogs this week:

February 24, 2009

Upcoming Webcast on the Hyperion User Conferences

One of the questions I get asked the most often is, "Now that the Hyperion Solutions conference is sadly no longer [pause for moment of quiet reflection] which conference should I be attending?"  The answer is remarkably confusing since there is no longer one catch all conference.  While I've been answering this question in person and on this blog for close to two years now, this is still a major point of confusion in the user, partner, and Oracle communities.

So on March 3 at 11AM Central and March 5 at 1PM Central, I'm going to be hosting brief (30-45 minute) presentations on all the major conferences and who should attend which ones.  Normally, the weekly interRel webcasts are not open to our competitors, but for this one topic, we are opening it up to everyone.  While I normally don't like training my competition, in this case, I figure the more people who know where to go, the better.

I'll be featuring the OpenWorld, Collaborate, and Kaleidoscope conferences, but I'll also be speaking briefly about the local HUGs (Hyperion User Groups) and their replacements at OAUG, IOUG, and ODTUG.  I'll cover which type of users should go to which conferences (and user groups) and I'll give you an idea of the agendas for Hyperion/EPM attendees you're likely to see at each conference.

If you don't want to end up at the wrong conference in 2009 and beyond, try to carve out a few minutes to attend one of these talks I'll be doing.  Feel free to send a link over to your friends (those people you're connected to on Facebook and LinkedIn) so they can attend too.  Each webcast can handle up to 1,000 people, so the more, the merrier!  Here's the link and I'll see you on March 3 or 5th:

January 9, 2009

#5. Users Don't Know Where to Go now that Solutions is Dead

In the summer of 2007, Hyperion held it's last Solutions conference, may she rest in peace.  The final USA Solutions attracted around 4,500 people.  There was some Hyperion content at Oracle OpenWorld in the fall of 2007, and most estimates put the Hyperion attendance at around 1,000 people.

So where would those 4,500+ users go in 2008?  Well, they had 4 choices:
- Collaborate (put on by OAUG, IOUG, and Quest) in the late Spring of 2008.
- Kaleidoscope (put on by ODTUG) in the Summer of 20008.
- OpenWorld (put on by Oracle) in the Fall of 2008.
But none of the users knew which was the correct one to attend.  Some former Hyperion sales reps recommended OpenWorld, some partners recommended Collaborate, and word of mouth was definitely favoring Kaleidoscope.

Some users went to one of those, some went to all three (like me), but most... didn't go to anyone at all.  Rough estimates of total Hyperion attendees at the three 2008 conferences was ~2,200.  Note that this is less than half of the 4,500 who went to Solutions 2007.  Where did those other 2,300 users go?  Frankly, they stayed home.  Considering Solutions was one of the best software conferences around, this was sad and best and criminal at worst.

Since 2008 was a year of complete disarray in the conference community, most people stayed away, waiting to see which conference would win.  From everything none of the three will be emerging as the clear winner.  I see the user community going to all three conferences depending on the type of users.

I really didn't like this conference in 2008, and I've become less enamored with it as time's gone on (and no, it's not just because they had the worst food I've seen since the "please sir, may I have more gruel?" scene in Oliver Twist).  My fundamental disappointment stemmed from two issues: lack of presentations and their complete and total disorganization.  It was partly to help solve these two issues that I volunteered to be a part of the OAUG Hyperion SIG for this year.

It does look like Collaborate is going to be more organized this year (with dedicated rooms for Hyperion/Essbase/EPM/BI/DW that are hopefully not spread all over tarnation/Orlando); however, I think the content will actually be decreased.  Last year had around 100 presentations and this year I expect the number will definitely not be that large.  Since last year was a starter year for Hyperion content at Collaborate, I'm boggled as to why they wouldn't be tripling their Oracle EPM presentations in 2009.  Solutions 2007 had close to 300 presentations on Hyperion!  Could it be that now that the Hyperion user groups have gone under the OAUG umbrella that they no longer have to make a show of having caring about the Hyperion community?

Anyway, while I hate to admit it, if you are an end user of the Hyperion/EPM products, there's probably no better conference for you than Collaborate with it's focus on case studies and higher-level presentations.  And yes, I will doubtless be presenting at Collaborate (and interRel will have a booth), so I'll see you there.  And yes, I'll be bringing my own food and I advise you to do the same.

I loved Kaleidoscope in 2008 (and not just because their food was awesome).  I felt that the content was awesome and I personally learned more at Kaleidoscope 2008 than I've learned at any Solutions conference in forever.  Now this may be because as co-chair of the Hyperion track, I helped select the presentations that I thought would be interesting to see, but all of the attendees seemed to agree.

I've seen the current agenda for K'Scope 2009 (all the cool kids call it "K'Scope") and it's impressive.  Visit http://www.odtugkaleidoscope.com/Proposed%20Agenda%20no%20speakers.pdf and you'll see that there are multiple tracks this year that goes beyond just Essbase and includes Planning, HFM, OBIEE, and the reporting & analysis products too.  Some highlights of the conference include themed days (like "Essbase optimization day!") featuring ~70 hardcore training sessions, hands-on labs to get actual classes on pre-setup laptops during the conference, and a Sunday symposium where the Oracle/Hyperion developers are going to spend all-day talking about EPM products still under development (compare that to the normal 1-hour whirlwind, high-level "what's new" presentation).  I also just found out that John Kopcke, head of the BI/EPM business unit at Oracle, will be delivering the overall conference keynote on Monday morning, June 22, and it's obvious that this is the conference to be at in 2009.

OpenWorld, on the other hand, is not the place to be in 2009.  While it's much better organized that Collaborate (and the food's better too), in 2008, it had even less content on EPM than Collaborate 2008 or for that matter, OpenWorld 2007.  I'm still stunned that this was even possible.  Again, why would you decrease your Hyperion content when this segment of your market is actually growing?

The only reason I go to OpenWorld (other than to speak, of course) is to hear Oracle has to say about Oracle.  Since Oracle dominates the event, you'll get what's new, what's coming, and what's the current marketing message straight from the horse's mouth.  If you like Ellison keynotes, OpenWorld is also the only place to be.

I see people who are used to Solutions, though, fleeing OpenWorld.  Judging by the attendance in presentations I went to in OpenWorld 2007 vs. 2008, there were fewer Hyperion attendees year over year.  My recommendation would be either K'Scope or Collaborate for 2009.

Interestingly, I did a webcast last week to 100+ Hyperion companies and during the webcast, I gave a poll to determine whether users would be going to Collaborate, K'Scope, or OpenWorld in 2009.  67% of the people on the survey said they were planning to attend... Kaleidoscope.

June 16, 2008

Kaleidoscope - Sunday

3:00 AM - Poker and Shopping Carts
We played poker until about 1AM. I was up several hundred dollars and decided to call it a night. While I like the poker action in the Harrah's poker room, I smell disgustingly like an ashtray. The poker room is nonsmoking, but it's in the middle of the smoking-encouraged casino floor. It's times like this that I miss the nonsmoking California card rooms.

I called my business partner, Eduardo Quiroz, to meet me at a small grocery/convenience store by the Sheraton. We needed to stock up our hospitality suite (curiously named the "Huey Long Suite") for the next few days. Eduardo and I filled two entire shopping carts with chips, dips, other snacks, and lots of "beverages."

We got to the front and paid before we faced the question: how do two guys not in very good shape carry two shopping carts full of stuff back to the hotel? We proposed multiple trips when one of the store employees volunteered to go with us back to the Sheraton. He was a nice young lad with a partially shaved head, a mohawk/mullet, 10+ body piercings, and a beard that resembled Jack Sparrow from Pirates of the Caribbean.

Eduardo and I pushed our bright red shopping carts up Canal Street with the upstanding youth in tow. We assumed he would walk us to the entrance of the hotel so we could transfer the items to a luggage cart, but he assured us that people regularly pushed shopping carts through Sheraton lobbies. We rattled across the lobby getting a couple of waves from the bellman and front desk personnel who really did seem like this sort of thing happens every day. On the elevator ride up to the suite, Piercing Boy said that normally the shopping carts were used to transport Bourbon Street drunks back to the hotel, so the Sheraton people were probably happy to see food and beverages in our carts.

Once we got to the 48th floor, we unloaded everything into the suite (which is huge with a great view, by the way). We tipped America's Future twenty dollars for his efforts, and he wheeled the carts out of the suite assuring us that he would see us tomorrow. Eduardo and I spent the next 90 minutes reviewing the conference so far before heading off to our respective, adjoining rooms to sleep.

It's 3AM, so I think I will have to miss the general session ("Web 2.0 meets the Enterprise" by Vince Casarez from Oracle). I don't want to miss Robin Hazel's Essbase keynote at 10:30, so I'm going to stop typing and sleep a mite.

8:00 PM - Welcome Reception
I got talking to people and missed the keynote from Tom Kyte: "How do you know what you know?" Apparently, it was quite entertaining. There are a few other people blogging about Kaleidoscope who you might want to follow this week (because these people do things like attend keynotes):
- Mark Rittman at http://www.rittmanmead.com/blog/
- Blogging About Software Development at http://www.bloggingaboutjava.org/2008/06/odtug-kaleidoscope-2008-the-pre-conference-conference/

Mark Rittman refers to New Orleans Bourbon Street as a cross between "Amsterdam and Animal House." True dat.

I did make it to the welcoming reception held in the exhibit hall (which was kinda small but this is a much smaller conference than OpenWorld, Collaborate, or Solutions). The entertainment for the reception was ad-hoc: they asked ODTUG members to get up on stage and jam. There was a fellow who did some nice jazz piano, but he's the only one I heard play.

The food was stellar (and my expectations are getting rather high). I won't detail the entire menu again, but it's worth noting that there was a pasta bar. I love pasta bars and this one was entirely vegetarian (which is rather odd) which made me love this pasta bar even more. There were also several appetizer stations (many serving hot food) and several open bars. Like everything else so far at this conference, this is world's above and beyond Collaborate.

I just finished sitting down at the reception to eat what basically amounts to dinner with a Gary Crisci, Glenn Schwartzberg, and Doug Bliss. A few people want to go play poker at Harrah's, and I have been known to play on occasion, so I just might join them.

5:00 PM
- Developer Panel
There was a developer's panel that Al Marciante put together. These panels can be helpful or disastrous. Sometimes people ask really off-the-wall, totally off topic questions. Sometimes they're remarkably enlightening. I'll paraphrase the questions/answers as best I can.

Q: What's the plan with the APIs?
A: The Java API is the go forward direction. The VB API is being kind of ignored. The C API has to be paid attention to because Essbase is written in it.

Q: How difficult is the upgrade from System 9 to 11.1.1?
A: It should just be an install in place (overwrite). It should be easy than Essbase 7x to System 9.

Q: Is there a global option to turn off implied shares?
A: Yes, there is in Kennedy, 11.1.1.

Q: [Really long-winded question about a specific Planning problem that pretty much no one could understand and was really specific to the questioner's company]?
A: [Great answer from Steve Liebermensch] I'm really not here to solve your specific implementation issue from up on the panel. [which is why I love Steve Liebermensch]

Q: Is ODI (Oracle Data Integrator) the replacement for HAL?
A: Yes, and if you own Planning, you can use a limited copy of ODI for free. The Essbase adapter, we think, is free, but you'll have to pay for ODI to load data into your straight Essbase apps.

Q: Does Oracle do concurrent ports?
A: No, just named and CPU licensing.

Q: Pre-acquisition, SAP was looking to put Essbase on top of BW? Is that still happening going forward?
A: Yes, as part of Oracle's push to surround and conquer SAP.

Q: What's the methodology for requesting enhancements? How do go about requesting changes?
A: Submit through support and it will get put into "Orion," Oracle's enhancement system.

Q: What versions of Office are dropped in Kennedy?
A: Office 2000.

Q: Is Kennedy Windows only?
A: Yes, it was the first slide of the day, actually.

Q: Is it supported across all the application servers then?
A: Yes, it is. All app servers (WebLogic, WebSphere, Tomcat) and both Firefox and Internet Explorer. If it runs on Windows and we traditionally support it, we'll support it in the first release of Kennedy.

Q: Are Financial Reporting, Web Analysis, and the like still being developed?
A: Yes, but we're Essbase developers, so we can't talk about it in detail. Ask Robin Hazel tomorrow since Robin will be talking more about that.

Q: Will Smart View support both member names and aliases in rows like the Essbase Add-In already does?
A: Parity between the add-ins needs to happen. It's trying to be in there for the Talleyrand, mid-2009, release.

Q: Is Block Storage going to be a passive technology in the background as ASO becomes the go-forward direction?
A: Yes, that's something we're looking at. Those conversations are happening but they're very far off.

Q: When will members on the fly be supported?
A: That's something that the team has looked at in the past and will probably be resurrected.

Q: Does Larry Ellison really like his new $3BB toy called Essbase?
A: Larry learned what he bought from Vaishnavi Sashikanth in December and he seems to be a big fan of Essbase. He enjoys the product now and Thomas Kurian, manager of the middleware group, really likes Essbase and wants to use it within all the Fusion apps. We have more to do than we have bodies to do it.

That's not an exhaustive list of questions, because I couldn't write them all down quickly enough. It was a pretty good panel though it went on a bit too long. Since I'm the one that scheduled a 2 hour developer's panel, this is definitely my fault.

Now we're all off to Tom Kyte's keynote "How Do You Know What You Know..." followed by a welcome reception (and jam session!) in the exhibit hall.

3:30 PM - Break
We had a brief snack/recharge break. The ODTUG food planners graced us with tasty
beignetes covered in powdered sugar. They also had soft drinks for sugar boosts!

3:00 PM
- JDeveloper
David Mellor and Duncan Mills from Oracle development gave a thorough demonstration of JDeveloper's Essbase access. JDeveloper is a long way off before it will be the primary development environment for Essbase web-applications. It's already there for other products, but it's a bit too... complicated right now for traditional Essbase development. I guess it's no more complicated than Hyperion Application Builder (or AlphaBlox, if you can remember that far back).

JDeveloper is the IDE for Oracle for J2EE applications, Web Services, WebCenter, Oracle database, XML, and someday Essbase. It has built-in version control. The editors include a visual editor (looks like a flow diagram), a dialog editor, and a code editor.

I was pleasantly surprised to hear that JDeveloper is free. It sounds like the Essbase component of JDeveloper is currently in beta. David started to say that it would be out this summer, but Duncan said that the development team would not say any more definite release date than "by the end of 2008." Both of these should be available (check OTN, I think he said) by the end of the year.

2:00 PM - Essbase Studio
I'm in post-lunch euphoria (and ready for nap time). The presentation I just saw was from a nice (and somewhat funny, though not as funny as Al) product development fellow named Subhash Gaur. He went through some Essbase Studio slides and then concluded with a demonstration of Essbase Studio that was a little difficult to follow but showed the power of the studio.

Essbase Studio is the next generation Essbase application building and administration. It's a graphical environment that seems at least as easy to use as EIS (though more IT-centric than EAS). One of the things that I saw today for the first time was "artifact lineage" which is basically impact analysis: when I change this dimension, which cubes will be changed?

I really like how ES (which replaces EIS immediately, but EAS not so much) creates rules files that can be kicked off independently of the studio. In other words, you can build a cube with data load and dimension build rules in studio, but then launch those rules independently via MaxL or EAS.

On a replacing EAS note, there's definitely a lesser need to use the Data Prep Editor in EAS. Essbase Studio lets you do a lot more rule-type activities than EAS does, but Subhash did admit that not every load rule function is in the studio. Future versions (Subhash referred to "Kennedy+") will replace a lot more EAS functionality including viewing/editing outlines, creating calc scripts, editing report scripts, and so on. There was no timeline listed for these enhancements.

Subhash went into detail about creating drill-through reports. Some of the nice things include dynamic association of reports (no more having to rebuild the cube to add reports), reusability of reports across cubes, and the expanded data sets for building cubes (RDBMS, flat file, Essbase, EPM Architect, and SAP R/3).

He talked about the future of Essbase Studio beyond the current release. Some of the planned enhancements include drill-through reports from cube to cube (so called "drill across" reports), localization, import/export XML (like EIS has now), the ability to cancel long tasks, and adding Netezza as a data source.

Next up is a look at JDeveloper's new Essbase access.

1:00 PM - Best Lunch I've Ever Had at a Conference
I almost skipped lunch, and that would have been my biggest mistake of the conference: lunch was truly amazing. I had the nice company of several people from the Hyperion track (including Al Marciante, John Rambeau, and Val Blackburn, all 10+ year veterans of Arbor Software out of the Dallas office). While company was nice, the food was superb and no, I don't just mean in comparison to the gruel from Collaborate.

Lunch was hot, you were given water or ice tea in real glasses, the tables had tablecloths, the silverware wasn't plastic, and it was served in a ballroom with high ceilings, skylights, and a gorgeous view of New Orleans. There were people coming by the tables to clear them and help you with any needs you might have. While all those things were 10 times better than Collaborate's attempt at lunches, check out today's menu (v for vegetarian):
-Smoked corn macque choux salad (v)
-Vidalia onion and creole tomato salad (v)
-Creole roasted new potatoes (v)
-Scane roasted spaghetti squash with julienne carrots and asparagus slivers (v)
-Pasta primavera with sundried tomatoes, olives, and capers (v)
-Grilled chicken with pecan rice, black eyed pea salsa, and roasted red pepper sauce
-Catfish fillet stuffed with crawfish and corn stuffing
-Gumbo ya-ya with chicken and sausage
-Super-soft dinner rolls

Oh, and did I mention that dessert was bourbon pecan pie with nutmeg creme anglaise? Recall that Collaborate gave out 3 Oreos for dessert (yes, THREE Oreos per person). I can metaphorically say I've died and gone to food heaven. I am really extremely impressed at how strikingly good everything I tried was (though I had to skip the sinfully good looking pecan pie since it's not vegetarian). While part of is the hotel doing a good job on the food, ODTUG spared no expense paying for lunch.

I know it's only half way through the first day, but I love this conference. Everything is so far done very professionally (though on a smaller scale attendance-wise, of course, than Collaborate or OpenWorld). Lunch today proved to me that the ODTUG people are not out to make a profit on this conference. I genuinely feel that ODTUG is putting the vast majority of the conference admission fees right back into the conference attendees.

I can't believe I'm writing this, but I can't wait for lunch tomorrow.

12:00 PM - Essbase 11.1.1 New Features
My mind is officially blown. Al's been talking for 2+ hours on all the new features in Essbase 11.1.1. He started off by covering the release schedule. Right now, Essbase 11.1.1.0.0 (the Windows only, English version) is scheduled for July 8. The code will be done by the end of June, but it won't push out until July 8 (subject to change, of course). The non-Windows version (code named "Kennedy 2" and was formerly code named "Shelley") is due out in the second half of 2008 and will be called 11.1.1.1.0. The Dickens version will support localization in the second half of 2008 and should be version 11.1.1.2.0.

There were several screen shots of the new Installation and Configuration product. It definitely seems simpler. There are four main screens and it does a good job of installing the products in the correct order and then auditing the install to make sure it actually works. On an "under the covers" note, there is now a single HYPERION_HOME location for all applications. Products will be under HYPERION_HOME\Products while application server deployments will be under HYPERION_HOME\Deployments. There are are also a few new environment variables including ESSBASEPATH which seems to actually replace ARBORPATH after 10+ years.

Lifecycle Management (LCM) is going to be part of Shared Services and launched through there. LCM is the product that allows an administrator to move objects (Planning, Essbase, Business Rules, HFM, EPM Architect, etc.) from environment to environment (like Development to Production). LCM will not migrate data from Essbase or HFM between servers. It does give you a nice report on what successfully migrated and what didn't. You can also run a report that compares environments and there's even an audit report that shows you a history of migrations. Apparently, you can migrate between different shared services servers which is a nice surprise You can't migrate between versions unless both shared services versions support LCM. Since right now the only version that supports LCM is 11.1.1.0.0 (not yet released), this is really only helpful moving forward.

There were a couple of minor enhancements mentioned. All the new logs (across all Hyperion products) will be in one common directory which should make it easier to troubleshoot issues that show up. Also, the default security for Essbase in 11.1.1 is not native (Essbase.SEC) security but rather it's Shared Services. Since Essbase native security is very insecure (remind me to show you some tricks one of these days on how to hack Essbase security), I'm glad they're trying to push people to Shared Services (and by extension, external authentication).

There was a lengthy discussion of Varying Attributes (AKA Slowly Changing Attributes) which is the ability of an attribute to vary across the intersection of 2 or more dimensions. For instance, the manager of a product may change from year to year. I took a ton of bullet notes on this:
- Can look at point-in-time (show me the relationships as how things were in January of 2007)
- Must build through Essbase Studio or manually through EAS. Not exposed through DimBuild rules in 11.1.1.
- There's a new outline property of a member: "Varying Attributes Enabled"
- Can do ranges (like "Bob was the manager from 2002-2005") without having to specify every member in the middle. It does this by going in outline order from Member X to Member Y.
- Appears as an attribute dimension
- Don't need to run a calc: they're dynamic like attribute dimensions

The discussion on Date and Text measures in Essbase was extremely lengthy. Suffice to say that "Text in an Essbase data cell" is the greatest enhancement to Essbase since Aggregate Storage (and maybe since Dynamical Calc members). Here are my bulleted notes:
- New Outline property: "Typed Attributes Enabled"
- Basically a text measure is a number used in a "VLookup." Because of that, you would never use text measures to store, say, an address for each customer, because every value would be unique to one lookup. You need a limited range of text measures.
- Dates are stored as numeric, so there are no limits to the dates allowed
- Writeback is allowed to a text/date measure
- Must create a "Text List" object (very similar to a SmartList)
- Can import in a mapping table of numerics to texts
- Date type measures can be used with new Text functions
- Supported in Smart View, Web Analysis and classic Add-In
- Al's not sure if text/date measures are supported in Financial Reporting 11.1.1
- Lookups are stored in a separate file referenced by the outline (OTL) in Essbase
- There are API calls for
- Maximum for text is 255 characters
- Users can't type in their own text: they have to select from a pre-established list
- 1024 different values in a Text List and NoData and OutOfRange
- Dates are recognized in Excel as dates (not text, very cool)
- Can use text measures instead of attributes or UDAs for member selection
- Can now format measures/accounts (and dynamic calc members of other dimensions) as a string using new property "Associate Format String"
- Dates stored as seconds since 1970 so dates are limited to 1970-2038. This will be corrected in future releases.

There are new MDX Time Intelligence functions that went by too quickly for me to note them. Suffice to say that there were at least 10 new functions. There were also some new calc script functions:
- @LANCESTORS (all the ancestors for a list of members)
- @LDESCENDANTS (all the descendants for a list of members)
- @SHIFTSIBLING (nth sibling of a specified member)
- @NEXTSIBLING (nth forward sibling of a member)
- @PRIORSIBLING (nth prior sibling of a member)
- $ (used to get an environment variable for the operating system into a calc script)

The new backup, transaction logging, and replay feature in Essbase BSO was explained further. It will record everything done to an Essbase cube such as outline changes, calc scripts run, data loads initiated, dimension builds, and lock&sends. You can then rollback specific transactions or replay specific transactions. You can't exactly cherry pick specific actions to replay after a crash, but you can specify, say, "everything from this time onward." It's basically a super-ramped up improvement/replacement for the old Essbase SSAUDIT setting.

Most of the items above (like date/text measures and varying attributes) are applicable to both BSO and ASO, but t
here are a few ASO specific improvements:
- Unicode support. Previously, only BSO cubes could be unicode.
- Partial data clear. You can set a region of data to 0 or #Missing using either a physical clear (it actually blanks out the members) or a logical clear (it creates a slice with a reversing entry in effect making the intersection equal to zero). On one of their test clients, a logical clear was 30 times faster than a physical clear, but a logical clear does add some time to the retrieval.
- Target of a partition. Data can now be transparently partitioned into an ASO cube.
- Writeback to level 0. You can now send data into the bottom intersections of an ASO cube (like BSO) although in ASO, data sent to upper levels is ignored.

There were a couple of slides on xOLAP, the technology that allows an entire Essbase cube to be stored in relational database. Why would one do this? A cube could be real-time on RDBMS data, for one. For another reason, doing this would allow the underlying table to still be accessible via standard SQL queries, if you're into that kind of thing. There wasn't a demo of the functionality and I haven't tried it out. My main concern has to do with speed. As some of you may recall, IBM once allowed storage of Essbase data in DB2 (it was one of the storage options in IBM DB2 OLAP). Everything ran slower (by about 3 times) when you tried storing data relationally. I just can't believe that RDBMS storage of cubes could be as fast as native storage, but maybe it won't be terribly much slower?

There was an interesting question from someone about whether there would be an Essbase Add-In for OpenOffice or Google's spreadshet. The answer was that right now, there were too few calls for it. While I agree, it would be nice for Essbase to be "the first BI application to allow ad-hoc analysis through Google's spreadsheet." I suspect that if they do this, it'll be a long while off.

Al showed a brief demo of the new Smart View Connection Manager and Smart Slice functionality. It seems extremely easy to set up a "starting view" of the cube using Smart Slices. The demo had to be cut short, sadly, because everyone in the audience was losing consciousness from lack of food, want of drink, and need of toilet.

Off to lunch, and I pray to the conference gods that it not be as bad as what Collaborate served us.

10:00 AM - Keynote on the Future of Essbase
Al Marciante just gave the keynote address "The Future of Essbase: Code Name Kennedy and Beyond" in place of Robert Gersten who was called away at the last minute to an Oracle event in EMEA. Al started off by giving a history of Essbase (and to a lesser extent, Hyperion as a whole). It's impressive to realize all the things where Essbase broke new ground (first to meet Dr. Codd's rules for an OLAP database, first to have a thin client, first to have a 64-bit server, first to have a Linux server, and so on).

Since today is all about the future of Hyperion, Al gave the standard "don't hold us to anything we're about to tell you" disclaimer slide. He then went into his three themes for today:
  • New applications & ERP Integration.
    Al started by talking more about Profitability Management 11.1.1. I've talked about this product before (it's basically a nice graphical tool for creating allocation models). He did mention today that HPM (Hyperion Profitability Management) is built entirely on Essbase. It actually creates calc scripts behind the scenes and utilized a multi-cube architecture (one for calculating and another for reporting).

    On ERP Integration, Oracle has resurrected the old PeopleSoft PeopleTools product that used to integrate PeopleSoft data with Essbase. It hadn't been updated in a long-time (as of Essbase 5 or 6), but starting with PeopleTools 8.49, it will support current versions of Essbase. PeopleSoft 9 will even be able to build cubes directly. The new version of Hyperion will also support seamless drill through to Oracle EBS (eBusiness Suite).

  • Comprehensive Analytic Application Framework
    Essbase is the new analytics standard for Oracle Fusion. In other words, all the new Fusion apps will use Essbase (most likely in a "lights out, behind the scenes" version) as the supporting database. Essbase will be integrated in the near future with all the financial, CRM, and procurement applications.

    JDeveloper will be the new front-end development tool against Hyperion going forward. Al wasn't exactly sure about the pricing for JDeveloper, but his opinion was that the "Essbase adapters" for JDeveloper would be free. What he wasn't sure about was if JDeveloper costs money to Essbase users or would be free. I'd be surprised if they didn't charge for it, because it looks like a very powerful, Java-based, Oracle-aware development tool.

    Al talked briefly about some of the newer features in Smart View. The three coolest things (which I've previously talked about) are the new Connection Manager (it's a tree now instead of bizarre URLs), Smart Slices (AKA personal cubes or making cubes seem like they have fewer dimensions than they really do), and what they're currently calling Report Designer which is the ability to make a dashboard in Microsoft Office of Hyperion-aware things like grids, tables, charts, and sliders.

  • Advanced Analytics
    There were two major points on Advanced Analytics. First was that Crystal Ball (that product Hyperion bought just before Oracle bought them) would be integrated into Hyperion for forecasting and optimization. Crystal Ball Predictor and OptQuest are being integrated with Smart View (and exposed through the web) for forecasting and optimization scenarios.

    The other major point was that data mining models will now be able to be created and visualized through HVE (Hyperion Visual Explorer). This is very cool, because right now data mining models have to be set up using a really kludgy interface in EAS.
After Al's talk, he released us for a brief break so we could catch up on our blogging (presumably).

9:00 AM - Welcome and Kickoff
We just finished kicking off the day. During our kickoff, a massive storm hit New Orleans. It gave the talk a lot more gravitas to have thunder cracking everywhere and lightning flashing outside the window.

Tim started off by polling the audience about their Essbase experience. It impressed me that there were 4 people in the audience who went to the very first Arbor Dimensions conference back in 1995. Tim was the only one who had an ESSBASE vanity license plate on his jeep. I did write a musical about Essbase, though, so I think I've also earned my Hyperion geek cred.

John Jeunette (President of ODTUG) and Mike Riley (Head of Kaleidoscope) both stepped forward to say a few words of welcome to the Hyperion attendees. I have been genuinely impressed at how welcoming the ODTUG people have been. Even though Hyperion is new to the ODTUG party, they've done a great job of making the new users feel at home.

I was assigned to give some announcements about the Hyperion track as well as Hyperion in general. I walked everyone through the "themed days" we'd be doing at Kaleidoscope and then briefed everyone about the ramifications of Kopcke's letter from last week. I introduced Al Marciante (Senior Director of Product Management in the Hyperion space) who'll be doing the keynote for the "Developer's Symposium" and then hurriedly sat down to write this blog.

8:30 AM - Preparing for the day
Tim and I are trying to do last minute preparations for our "Welcome and Kickoff for the week" presentation, but we keep stopping to talk to people we know. The problem is that we know darned near everyone hear. My rough count shows over 100 people here which considering it's Sunday morning (and Father's Day, no less) is fairly impressive. I was worried we'd have around 11 people and that would include the 6 interRel people here, Tim Tow, and Al Marciante.

Oracle was kind enough to pay for copies of Look Smarter Than You Are With Essbase System 9 for every attendee in the Hyperion track here at Kaleidoscope. It's neat to see everyone walking around with a copy of the book with the special "Limited Edition for ODTUG Kaleidoscope" banner on it.