September 16, 2009
May 8, 2009
May 4, 2009
- (This bullet intentionally left blank.)
- 9:45AM - Visual Analysis going beyond grids and two dimensional charts in room W230D. This is my first session at this conference with a client or to be more specific, a partner. Deepak from Tableau will be talking about using Visual Explorer against Essbase and other data sources. I'm really just there to answer questions.
- 11:00AM - Workarounds for What the Essbase Developers Forgot in room W101B. My second presentation of the day (with all of 15 minutes between even though they're on completely opposite sides of the Orange County Convention Center) is sort of a "Hacking Essbase" presentation. If it's not there in current versions of Essbase, I'm going to be showing how to workaround it. This will either be really well attended or no one will be there because it's totally wrong for the Collaborate audience.
- 3:15PM - Essbase Aggregate Storage is the way of the Future. My final presentation of the day is on how under 11x, Essbase cubes should be assumed to be ASO until BSO proves to be necessary. I'm supposed to be presenting with Matt Hanselman from American Girl but to some budgetary restrictions, he couldn't make the conference. Guess I'm presenting this one by myself!
- 5:30PM - Happy Hour Reception in the exhibit hall. Back to the exhibit hall for more fun, frivolity, and maybe even more decent food?!?
- 7:00PM - Customer Appreciation Dinner. My company is taking several of our clients out to eat at Pat O'Brien's. It's on Universal City Walk so afterwards, we'll have access to all the City Walk clubs. I'll probably end up out until midnight or later.
May 3, 2009
- 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.
September 26, 2008
- What's New sessions. While I heard very little strikingly new information about Hyperion (or "Oracle EPM," which I may never get used to saying), a lot of rumors were confirmed by official people in official settings. It's nice to hear people go under the record (even though many did it after showing a disclaimer slide saying basically "don't hold me to anything I say, because I'm liable to change my mind in a New York minute").
- Positive Hyperion vibe. I'm not just talking about the vibe headed interRel's way from Oracle (thank you again for the awards, Mr. Ellison, sir). What I mean is that Hyperion, Essbase, and EPM were on a number of people's lips. Thomas Kurian couldn't stop saying Hyperion (and Rich Clayton couldn't stop demoing Hyperion) for the majority of the Middleware Keynote, for example. To paraphrase John Kopcke, it's not a question of how will Oracle change Hyperion, but rather, how will Hyperion change Oracle?
- Sense of Community. It's good to get together with fellow Hyperion customers, partners, and Oracle sales people and there were a number of them here. I kept running into the same people at various events (Hyperion sessions, user group meetings, the interRel reception, the Oracle/OAUG reception, the EPM think tank, exhibit halls, and more) which gave me the nice feeling that we were all in this together. That said, I think the Hyperion attendance was down from last year. I think a lot of clients are going to Collaborate or Kaleidoscope (more on this in a bit).
- Most of the stuff doesn't matter to Hyperion visitors. 95%+ of the content isn't relevant to the people here for Hyperion. That would be okay if it was a lot more obvious upfront which sessions were relevant and which ones weren't. Larry Ellison, God bless his soul, didn't say a thing that mattered to the EPM-only visitors to the conference. Can you imagine if the Hyperion Solutions conference had a time designated for a keynote where nothing else was happening... and the keynote was all about the price of car mufflers in China?
- Too much marketing. Yes, I know I've said in the past that OpenWorld is Oracle's chance to talk about Oracle, so why was I expecting anything but non-stop marketing? I guess I was hoping for the best, but expecting the worst. Collaborate has some marketing-level presentations (as did Hyperion Solutions conferences) but OpenWorld ratchets it up a few hundred notches. Imagine sitting through 5 straight days of sales pitches from your software vendor. Sound like fun? Then OpenWorld is for you!
- Not much information. With the exception of SOME of the What's New presentations, I didn't learn anything. This may just be me rehashing the last point. A lot of the presentations are marketing from beginning to end. Okay, so if it's going to be a non-stop product briefing (and not training, as many who have gone to Hyperion Solutions conferences in the past have come to expect), then don't charge people to attend. Those people who came expecting to go back to their companies with actionable tips on better ways to use Hyperion products were (with far and few between exceptions), went away disappointed.
- Too big. OpenWorld needs to be chopped up. There were relevant Hyperion (Oracle EPM, sorry) events at Moscone West, Moscone North, Moscone South, the Marriott, the Hilton, the Hyatt, and the Westin St. Francis. No, those places are not all next to each other. I've walked so much this week that I've lost 5 pounds. Split up the technology and the applications into two different conferences or come up with some other arbitrary breaking point. The only value of having the entire user base together at one event is that the appreciation party can afford higher end talent (Elvis Costello is no Billy Joel, though). Oh, and Ellison only has to speak once.
September 24, 2008
September 20, 2008
11:35 PM: Back at the hotel
We just got back from Annabelle's. Due to the size of our group, we had a special "limited menu" which had a small amount of vegetarian food in addition to the meat plethora. They started out by bringing us plates of meat with some vegetables on them, bread, and mounds of calimari. I ate the veggies not touching the meat (mostly tomatoes and cheese) and sampled some rather fluffy bread. For the main part of the meal, I had zucchini parmesan soup and risotto primavera (arborio rice, petit vegetables, greens, and 3 cheeses). It was all rather tasty.
It took hours to go through all the courses. Apparently, service is not Annabelle's strongpoint. My friend, Mike Riley, the ODTUG Kaleidoscope content chair, was about 90 minutes late for the meal. Apparently, he was taking the elevator down at the Marriott with Debra Lilley from UKOUG when the elevator temporarily forgot that an elevator's job is to move people up and down. Elevator 11 decided that it wanted to go on some sort of work strike and stop between the 10th and 11th floors.
It took over 90 minutes for the Marriott to get someone from Otis to come out and save Mike and Debra. The Otis guy had to get onto the roof of the adjoining elevator, lower it down to their level, and push on some rollers to get the door to Mike & Debra's elevator to open. They then climbed onto a chair to squeeze out between floors. While one might think that all this would be kind of scary, Debra seemed to be having the time of her life. She live blogged the entire experience on her blog:
Debra has quite the dry British sense of humor. For instance, during her ordeal, she went on the social network Oracle Mix site and created a "Stuck in an elevator at OpenWorld" group (only Debra and Mike are allowed to join). I'm glad to hear they're both safe, and should you be about to board an elevator with either of these two individuals, go ahead and let it pass. It's better to have to wait 3 minutes for another elevator than to have to be stuck in a small metal box 100+ feet above the ground with only a couple of cables holding you away from plummeting to certain death.
I'm back at the hotel now (after a quick stop at Walgreen's for water and granola bars) preparing for my "How Essbase Thinks" presentation at 1PM in Moscone West, room 3016. Eduardo and I stopped by 3016 earlier today. It looks like it holds about 300 people. I'm starting to fall asleep, so I guess I'd better get to the PowerPoint review. I'm sure that'll wake me right up.
That's all for today, but tomorrow starts at 10AM with the Oracle ACE Director product briefing. Fun, fun, fun!
6:22 PM: Registration and Annabelle's
Eduardo and I took the shuttle bus from our hotel to the Moscone Center because we weren't sure how far of a walk it was. Turns out to be about 7 blocks and totally walkable. We registered at Moscone South and caused quite a stir. Eduardo was "Oracle Club Gold" and apparently, the first of the day. The Gold level entitles Eduardo to a new iPod Touch (which they had to go find), 25% off at the Oracle Bookstore, better food at lunch, better seating at keynotes, and access to a lounge with free drinks and snacks. I'm not sure why Eduardo got the Gold level and I didn't, but I am in no way jealous of that jerk.
I confused the Oracle registration personal, because I am a speaker, an official blogger, and an Oracle ACE Director. Each of these designations entitles me to free OpenWorld pass, so no one could quite figure out where I was supposed to register. A nice lady at speaker registration ended up helping me.
Speaking of Eduardo, I've asked him to provide color commentary of this week's OpenWorld proceedings. He'll be talking about random things that interest him at the conference in the hopes of lightening up my normally oh, so staid blog. I've also asked him to take a few pictures, because as many of you have pointed out, my blog is seriously lacking in visual stimulation. I've always felt that a 1,000 words are better than a picture, but Eduardo is more of a "big picture" type of guy. We just spent an hour touring the Moscone taking pictures of the massive set up under way. He'll probably post a picture or two.
I'm now sitting at Annabelle's Bar & Bistro which is about 2 blocks from the Moscone. I thought the ODTUG get-together dinner started at 6PM, but apparently it was 6:30PM. The table is set for 12, and as of 6:22PM, there are only 3 of us so far. Oh, a ton of people just walked in. More later...
4:00 PM: Checking in at the hotel
I just go to the Serrano hotel. It's cute and quirky. They are supposedly all about having fun, so they have lots of games to play in the lobby and in the room. The lobby has Scrabble, Jenga, Monopoly, and the like. The room has more solitary fun including a deck of cards, a yo-yo, and a small-footprint Etch a Sketch. They're hosting a wine reception tonight from 5-6PM that will include - and no, I'm not making this up - a game of Twister. While that sounds fun in principle, a game of Twister with potentially drunk strangers sounds like there may be a full blown hootenanny in store.
interRel's co-founder, Eduardo Quiroz, and I are off to register at Moscone South. After that, we have dinner with the nice people from ODTUG, so I probably won't be posting again until late this evening.
2:30 PM: Baggage Claim
Forget everything I said: I love OpenWorld. Why? Because the kind folks from the Oracle ACE group sent a limousine to pick me up at the airport. There’s nothing cooler than getting to baggage claim and there’s some guy (let’s call him “Jeeves”) waiting for you with a sign that says your name on it. I felt like a rock star, so I treated baggage claim to some “Free Bird” on air guitar. I’m going to presume that the people laughing were laughing with me not at me.
Okay, I’ll admit that Jeeve’s sign did say “Rosky” (instead of Roske) but close enough for me. Limo drivers aren’t hired for their spelling ability, I’m assuming. You don’t suppose that there’s some guy actually out there named “Rosky” who was expecting a limo do you? Well, he should care more about the environment and take public transportation anyway. Think green, Mr. Rosky. Think green.
As I am chauffeured in luxurious style to my hotel, I’m going to contemplate whether or not Oracle is trying to bribe me and whether or not I’m susceptible to bribes. In the meantime, I love you, Oracle, and I want you to have my baby.
No, bribes have no effect on me. I’m sure of it. Jeeves, could you please pass me the bottle of bubbly? Non-alcoholic, please, I’m working.
1:07 PM: Still on the airplane
I ended up listening to several podcasts from the “Get it Done Guy’s Quick and Dirty Tips.” While I normally enjoy them, I was starting to fall asleep, and as I am forbidding myself from sleeping for the next week (standard conference rules apply), I opened my laptop back up.
So what am I least looking forward to about OOW?
- Hordes of people. Have you ever seen the battle scenes in the Lord of the Rings movies betweens 1,000s of orcs and humans? OpenWorld is kinda like that but without the good CGI. But Edward, not to point out the massive flaw in your logic, but you said you’re here for networking and that sorta requires people, doesn’t it? To clarify, I love the individual attendees, it’s the massive addition of 45,000-50,000 to the San Francisco eco-system that I can’t stand. OOW has gotten too massive for its own good. Let’s say that there are 1,000 people at OOW interested in Oracle EPM. That means the odds that the random person sitting next to you at lunch is also there for Hyperion? Around 50-to-1. OpenWorld really needs to be broken up into a series of smaller conferences (on that note, try Kaleidoscope or Collaborate).
- Neverending marketing. I’m all for a good sales pitch once in a while: it’s day-after-day of it that I can’t stand. Oracle is the best enterprise software developer in the world (sorry, Microsoft, but a lot of your products, to repeat a phrase I heard last week, “suck like Vista”). Oracle is one of the best software acquisition companies in the world (I’m still impressed at how they can acquire and then integrate multi-billion dollar companies so quickly). But where Oracle is one of the best companies regardless of industry is in their ability to market themselves. While I admire their marketing abilities, it gets old after a week of non-stop commercials.
- Conference food. I know it’s petty, but the food at these conferences is generally horrible (though admittedly, OOW has better food than Collaborate). I normally lose 2-4 pounds being at one of these conferences for a week. Kaleidoscope was the notable exception where their food was so good I gained 3 pounds. (Stay away from Kaleidoscope if you’re on a crash diet.)
- Exhaustion. For those of you who haven’t been, it’s almost difficult to comprehend the massiveness of this conference. It takes up two convention centers, two massive exhibit halls, several hotels, and frankly, the entire San Francisco bay area. This would be hard enough to navigate (without blisters) in a normal city, but San Francisco is not exactly flat. Add to that the fact that the days start at dawn with networking breakfasts, continue with presentations throughout the day, then it’s on to dinner(s) followed by receptions and parties, and by the time you get back to your hotel at midnight (and later) each day, you can barely stand. I wonder if it’s too late to rent a Segway?
I was going to try and post this entry now, but it looks there’s no high-speed internet 30,000 over Northwestern Nevada. Maybe when I land…
12:34 PM: Airplane
Life is a series of events, some memorably great and some forgettably mundane. Most of them are mundane, to be honest. At this moment, I’m on a plane headed from DFW to San Francisco. Looking around, I see familiar faces from interRel, Oracle, our clients, and our competitors. Some faces I don’t recognize, but they’re Oracle-branded bags and Oracle-themed accessories lead me to believe that half the plane is headed to OpenWorld.
This is probably my last bit of down time before the mania that is OOW starts, so I’m going to take a moment to collect my innermost personal thoughts (and share them with my close friends on the internet). Here’s what I’m hoping to get out of OOW:
1. Breaking news. There won’t be many out of the ordinary events. OOW is a tightly controlled marketing event. Everything that can be scripted is planned out to the nth degree… but that does include news that Oracle wants to share. I’m hoping for lots of “What’s New” information about the EPM products. Also, once in a while you’ll get someone on an open mike (Robert Gersten is famous for this) who lets a few things slip that aren’t sanitized through a marketing department first.
2. Education. My expectations are low in this area, but I do have some. While the content at OOW is less training-centric and more information-centric, Oracle does try to educate their clients on their product lines. If nothing else, by the end of the week, I’ll be fully educated in Oracle’s marketing message of the moment.
3. Networking. I must admit that I’m not a big networking guy. I realize the value of it, I’m just not very good at it. Even after 11 years of heading up interRel, I still don’t feel comfortable walking up to someone and initiating small talk. This might strike some people as strange who’ve seen me comfortably give presentations to rooms of 1,000+ and just conclude that I’m an extrovert. To be honest, one of the reasons I deliver more presentations at Hyperion conferences than anyone in his right mind would is that it gives people an opportunity to come up to me. When I give a talk or hold a book signing, people naturally come up to the front of the room afterwards and start up a conversation. The next thing you know, we’re friends for life (especially if it turns out we both wore the same shirt, because for guys, that’s a serious bonding point). Word of advice: go up to the speaker after a presentation and introduce yourself: you have a point of commonality (you were interested in the topic that the speaker was delivering) and sometimes that’s all it takes to expand your network.
4. Presenting. I have 4 presentations at the conference and since I’m one of those rare (some say “perverted”) people who enjoy public speaking, I’m actually looking forward to all of them. I like sharing information, and as I already mentioned, it’s a great way for expand my network. And once in a while, it actually results in some…
5. Sales. Someone just might come up to me at the conference and ask if interRel can come out and do Hyperion consulting for them. Stop laughing: one of our largest clients reached out to me after a presentation (I think it was on optimizing Hyperion Planning forms). Sales don’t always have to be outward. If you’re doing your job right, customers will reach out to you.
I think I’ll take a break for a moment and watch Fringe or True Blood (escapist TV shows) on my iPhone. Did I mention I absolutely, unconditionally love my iPhone (except for the lousy reception, dropped calls, and low battery life)?
I’m going to try to post this entry from the airplane, but the WiFi reception over New Mexico is atrocious.
June 16, 2008
After the presentation, the 6 people here from interRel tried to find a restaurant that everyone could agree on. Every one of us had one or more bizarre dietary issues making a single restaurant problematic. Here were some of our individual quirks:
- One person can't eat seafood.
- One person is a vegan (and doesn't like to eat salad, go figure).
- One person can't eat anything with pepper in it.
- One person can't eat wheat.
Combine all of those and we have no options at all in New Orleans (at least for traditional French, Creole, or other New Orleans fare). We ended up at an African restaurant serving food from Cameroon and Ghambia (seriously: Bennachin). The food was tasty if a bit unpronounceable and in some cases, unidentifiable. I had fried plantains (adios, diet), black eyed pea fritters, and something that merged eggplant, cous cous, and curry. Those were all good, but I really did not enjoy the pounded yams. I was expecting mashed potatoes and got, well, paste. It brought back not so fond memories of my kindergarten years. I think it was supposed to be really bland to blunt the spiciness of the curry, but the cous cous worked just fine for that.
I'm actually getting to bed early tonight to prepare for programming & automation sessions tomorrow from 8AM-6PM. Note to self: design next year's agenda to be a lot densely packed with presentations.
6:00PM - Migration to ASO from BSO
Steve Liebermensch, Consulting Technical Director in the Enterprise Solutions Group at Oracle, gave a presentation on converting BSO cubes to ASO cubes. I came up with the topic and asked Steve to deliver it and he did a bang up job.
He covered why to migrate to ASO, functional differences between BSO and ASO, MDX to Calc Script equivalents, migrating Sample Basic (as an example), and Gotchas of migration.
Why to migrate from BSO to ASO:
-Decrease update window
-Reduce database size
-Increase dimension size
Functional differences between BSO and ASO:
-Upper level loading
-Procedural calculations (calc scripts to do things like currency conversion)
-Native expense handling
-Dynamic time series (not in 9.3.1 or 11.1.1, despite rumors to the contrary)
-Stored results of subtraction (as soon as a dimension has a minus sign on a single member, that dimension must be dynamic in ASO)
-Attribute dimension functionality (any dimension can have an attribute in ASO and it's worth pointing out that attributes perform must better on attribute dimensions)
-Unit * Rate calculations
-Upper-level data load
He made a good point that people shouldn't convert a cube to ASO if BSO is working just fine. Steve's giving a presentation on Wednesday about optimizing ASO cubes and I'm sure it will go as well.
5:00PM - ASO: Understanding MDX
Glenn Schwartzberg, Oracle Hyperion ACE and ODTUG Ambassador, wore a jester hat to introduce Gary Crisci, Oracle Hyperion ACE. Glenn gave a personal ad for Gary that was Hyperion-centric and humorous. Gary started off by thanking me and Tim for putting the track together which was extremely gracious. He commented that some people told him that they feel they've gotten better information so far at this conference than at any Hyperion conference they've been to.
I won't be able to repeat everything Gary Crisci said, but I'll try to draw out some points that some people might not know. Gary pointed out that MDX is used to query both Essbase BSO and ASO cubes but can only be used in ASO cubes. He also pointed out that MDX is used for both querying metadata and data. For additional MDX help, go to the Essbase Technical Reference and visit MDX->Aggregate Storage Topics->MDX Outline Formulas (in System 9 and later).
Steve Liebermensch pointed out that some of the tips Gary gave for doing things like Time Balancing change between Essbase ASO 7x, System 9, and 11.1.1. Steve promised to go into these more on Wednesday during his ASO optimization presentation.
Gary recommended two MDX books:
- Fast Track to MDX; 2004; by Whitehorn, Zare, Pasumansky
- MDX Solutions with Microsoft SQL Server Analysis Server 2005 and Hyperion Essbase, 2nd Edition; 2006; by Spofford, Harinath, Webb, Huang, Civardi
Tracy McMullen (best co-author ever) pointed out that the Read Me files with each file list all the new MDX functions in each version. You have to read all the Read Me files if you started MDX under 7 and are now on later versions. She also pointed out that MDX shouldn't be used for bulk exports; one should look to report scripts or do a calc script export.
Someone asked if MDX has variance financial intelligence? The answer was that you can do it with a UDA and an IIF function.
Gary promised to get his slides & examples up on the ODTUG website. When I notice, I'll blog it here. Gary gave a great presentation (he's a fun guy). I'm going to ask him to speak at events in the future.
3:40PM - 64-Bit Essbase
The "Power of 64-Bit Essbase" presentation with Tim went well. I ran about 10 minutes over, but that's because we had time at the beginning of the presentation for interRel and AppliedOLAP commercials.
While my presentation went on for 30+ slides, there were two points that I wanted everyone to remember:
- Consider using 64-bit if you want to build bigger cubes with more concurrency on users and CPUs but be aware that 64-bit is not as stable as 32-bit.
- Throw away all the old optimization tips and try everything again with 64-bit.
After the presentation, we're breaking for 20 minutes for soft drinks and cookies.
2:15PM - Large Scale Implementation Panel
I just attended a panel on Large Scale Implementations of Essbase headed by Steve Liebermensch from Oracle who is also the moderator for the day. I was the one who recruited the panel members:
-Jay White, MDAnderson Cancer Center
-Andy North, Alcon Laboratories
-Rob Donahue, WhittmanHart
-Gary Crisci, Morgan Stanley
-Jason Novikoff, interRel Consulting
Here are the questions as best as I can paraphrase:
Q: What's your definition of a large-scale implementation? User count, number of cubes, large number of cubes?
Gary: Anything that would cause a block storage cube to break. Maybe the biggest dimension has 50-60K members, but it takes a lot of people working together to get it to work.
Jay: Number of users, number of load files, number of dimensions. A lot of it has to do with complexity.
Rob: A departmental solution isn't enterprise-wide. Number of users, cubes, and infrastructure requirements.
Jason: Number of users can drive your architecture. You can make several services redundant, you can load balance your cube... You need to load balance your cube.
Q: What should you do to load balance using what used to be Spreadsheet Services then Deployment Services and is now APS?
Gary: We're setting up SAN-based storage with clustering. Multiple servers are accessing a central SAN drive storage. It's good for business continuity planning (BCP) if the building burns down or whatever.
Andy: We basically ZIP up exports for backup purposes.
Jay: We run multiple servers. We literally run from 3 different physical locations for redundancy and continuity.
Steve: If you want true redundancy, you have to double your storage, but if you just want duplicate servers, you can feed everything off a central Storage Area Network.
Q: Are you running multiple environments?
Jay: We run multiple versions, because not everyone at our company is comfortable with System 9.
Gary: Our SQL farm is better funded and staffed than our Essbase farm, so we leverage the SQL farm to help us recover from backups more quickly.
Q: Has Oracle changed messaging these days? Why is IT supporting Essbase more?
Gary: Oracle buying Essbase has gained IT support?
Rob: Compliance and SarbOx. IT has to have a compliant system and support that system. Essbase is now a multi-tier solution used across the enterprise.
Q: Have you discussed why you might want to go to System 9?
Andy: We just signed the contract to go to System 9.
Gary: Good month for Oracle sales: we just signed ours to.
Andy: Our reason is mostly to stay in support not features really. It's a small group involved right now.
Jason: One of the driving factors for RadioShack for going to System 9 was for reporting purposes. For our new reporting project, they wanted to go from Crystal Reports to Interactive Reporting. We wanted to be on System 9 for the new IR reporting.
Q: How do you enforce playing nicely with others in a shared environment?
Jay: We don't play nicely. We were wholly owned by finance and now we're owned by IT. What we did (as a not for profit) was to break across multiple servers.
Andy: We broke up servers along departments, so if you're stepping on someone, you're stepping on your own group.
Q: How many people in the audience report up through IT?
A: [about 20%]
Q: How many report up through finance?
A: [about 80%]
Q: And how many of those have changed from finance to IT or the other way around?
A: [about 10%]
Q: How do you measure ROI on a large-scale implementation
Jay: We're rolling out System 9 right now. Part of our methodology is you must prove ROI. We justified our ROI was single sign-on across all the various applications we use.
Q: Have you built BI Competency Centers (AKA Centers of Excellence)?
Rob: We've seen some at some of our clients but leadership has to be on-board.
Jay: We've hired outside help to work with us to create a Center of Excellence.
Q: What blows away your capacity planning? Lots of concurrent users? Running big queries? Lots of simultaneous calcs?
Jay: We set limits in our Essbase config so queries can't run more than 180 seconds.
Q: How do you handle backing up Essbase cubes and defragmenting cubes with users demanding 24x7 uptime?
Steve: A Planning cube has to have downtime. A reporting cube can do things with partitioning and swapping cubes (even if you don't use clustering) to give close to 24x7 uptime.
Q: How many Essbase support people do you have?
Jay: We have 3 areas and have 42 people supporting the applications across those 3 areas. 3 of those are admins and we have 5 Oracle DBAs supporting our Hyperion apps too.
Gary: We have 7-8 developers, 6-9 production DBAs, and 5-6 people in our infrastructure team.
I enjoyed the panel although like most panels, a couple of people dominated the panel answers. Steve did a fabulous job of getting the panel to open up as much as he could and spread the answers around. I don't know if he'll let me talk him into something like this again, but I would definitely hit up Steve Liebermensch to host a panel for me again. Not only is he entertaining, he keeps the off-topic questions to a minimum.
Tim Tow and I are about to deliver a vendor presentation on 64-bit Essbase. It's officially a paid presentation, but that's only because I didn't want someone else buying the timeslot and making me sit through a 60-minute advertisement. If anyone wants the slides because you're considering going to 64-bit Essbase, e-mail me at email@example.com.
1:15PM - Lunch
Lunch was a hot plated meal. It was admittedly tasty but I liked the options of the yesterday's buffet more. I'm still satiated, though, and they brought me a vegetarian portobello and potato cake.
It's time to head back to the Essbase room for the Large Scale Implementation Panel.
11:33AM - Essbase Keynote
I did indeed miss both breakfast and the general session. I got to the Essbase ballroom 30 minutes before the keynote only to find that some guy from Pinnacle snagged my choice spot by the only power supply near the seating area. I'll have to blog without a table today so I can go sit by an electric outlet.
ODTUG Ambassador Gary Crisci (Oracle ACE from Morgan Stanley) introduced Robin Hazel, Oracle's Director of Strategy for Essbase. Robin Hazel has what seems to be a very realistic British accent, so I can only assume he's intelligent. He started off with the boring disclaimer slide that most people in the audience can quote from memory at this point. He then continued on into the EPM System Vision slide (the cycle of EPM that Hyperion created: Set Goals, Plan, Monitor, Analyze, Report, Align, repeat as necessary).
He covered the architecture of Oracle's EPM layer. The EPM Workspace sits on EPM Applications (Planning, HFM, Strategic Finance, Profitability Management, etc.) and BI Applications (the pre-packaged OBIEE apps that came from Siebel Analytics). Those sit on the BI Foundation (Essbase, BI Server, and Predictive Analytics). The BI Foundation sits on Fusion Middleware which sits on all the underlying data sources. That's a lot of sitting. I really should find the EPM architecture slide to show this visually. I just found an image at http://www.oracle.com/solutions/business_intelligence/docs/epm-system-graphic.pdf:
Robin addressed the Oracle OLAP elephant in the room: What's going on with Oracle OLAP (the old Express) now that Essbase is owned by Oracle? Here are Robin's differentiators:
- Essbase is for heterogeneous data and OLAP is for Oracle-centric data.
- Essbase is owned by lines of business (end users) and OLAP is owned by IT.
- Metadata in Essbase is owned by users and OLAP metadata is owned by IT.
- Essbase has hot pluggable data sources whereas Oracle OLAP has hot pluggable BI Tools.
In other words, Essbase is driven by the users whereas Oracle OLAP is driven by the IT organization for enhanced data warehousing.
He tackled the question of "Why does Oracle love Essbase?" (his words, not mine):
- It has the richest business user experience. It has excellent Microsoft Office integration and a range of superior reporting tools (like Financial Reporting, Web Analysis, and Visual Explorer). It also has Smart Space (the only persistent, always on BI/EPM gadgets in the world).
- It has a highly advanced calculation engine. They're now claiming 350+ functions which is a stretch unless you count some functions multiple times based on optional arguments, but the function library is impressive nonetheless.
- A bunch of other reasons that the readers of this blog already know. At one point, Robin opened up the keynote to the audience to tell their stories about non-financial applications of Essbase.
Oracle seems interested in getting Essbase out of its "financial niche."
Robin gave an interesting slide titled "10 Things You Can Do Today to Prepare for Oracle Fusion Applications":
- Move to the latest applications releases.
- Prepare a roadmap to evolve to Oracle Fusion applications.
- Inventory your enterprise assets.
- Rethink your "customization" strategy.
- Consolidate your master data.
- Embrace SOA-based integration.
- Extend your BI applications portfolio.
- Adopt enterprise reporting & publishing.
- Secure your global enterprise.
- Centralize your application's lifecycle management.
It's off to lunch. After yesterday's foodapalooza, I'm excited. I can't say that I've ever really felt that way about conference food before.