Showing posts with label Rittman. Show all posts
Showing posts with label Rittman. Show all posts

June 6, 2013

Looking Forward to Kscope13

On June 9, the rates for Kscope13 go up $300 per person (basically, you're going up to the last minute, I-don't-know-why-I-waited-but-now-it-costs-a-lot-more price).  If you haven't registered yet for what is by far the best Oracle EPM, BI, Hyperion, Business Analytics, Essbase, etc. conference in the world, go right now to kscope13.com and register.  It'll be the best training experience of the year: you're basically getting 4.5 days of training that you won't see anywhere else the entire year... for the price of 2 days of training at an Oracle training center.

And when you register, don't forget to use promo code IRC to save $100 off whatever the current rate is.

The conference is June 23-27 in New Orleans though my favorite day is always the opening Sunday, so make sure you fly in Saturday night.  On Sunday, they turn the sessions over to the Oracle Development team to talk about everything they have planned for the next 1-3 years.  It's the one time each year that you can hear right from the people who are building it what you're going to be seeing in the future.  There's generally an hour on each major product line (an hour on Essbase, an hour on Hyperion Planning, an hour on mobile BI, etc.).  The keynote this year is Balaji Yelamanchili, the head of Oracle BI and EPM development for Oracle.  My only semi-complaint about this year's BI/EPM Symposium is that there's so much content that they're splitting it into three concurrent symposiums: Business Intelligence, EPM, and a special symposium for the EPM business users.

This year will be somewhat bittersweet for me since I am no longer actively involved with the chairing of the conference.  This means that I get to focus on going to sessions, learning things, playing/leading Werewolf games, and of course, presenting a few sessions.  Here are the ones I'm personally teaching:


  • Using OBIEE to Retrieve Essbase Data:  The 7 Steps You Won’t Find Written Down.  This is in the BI track and it's basically all the quirks about connecting OBIEE to Essbase in a way that uses the strengths of each product.
  • What’s New in OBIEE 11.1.1.7: Oracle on Your iPhone & Other Cool Things.  This is also in the BI track and it's an overview of all the things that people will like in 11.1.1.6 (for both Hyperion and relational audiences).
  • Everything You Know About Essbase Optimization  is Incomplete, Outdated, Or Just Plain Wrong.  This is in the Essbase track and it's the one I'm most looking forward to delivering, because I get to break all of the optimization rules we all have been accepting as gospel for close to 20 years.
  • Learn From Common Mistakes: Pitfalls to Avoid In Your Hyperion Planning Implementation.  This is a vendor presentation hosted by interRel.  I get to sit on the panel and answer Planning questions from the audience while talking about blunders I've seen during Planning implementations.  It should be fun/rousing.  Since it's all interRel, I wouldn't be surprised if a few punches were thrown or at minimum, a few HR violations were issued.
  • Innovations in BI:  Oracle Business Intelligence against Essbase & Relational (parts 1 and 2).  This is also in the BI track (somehow I became a BI speaker???) and I'm co-presenting this session with Stewart Bryson from Rittman Mead.  We'll be going over OBIEE on Essbase on relational and compare it to OBIEE on relational directly.  Stewart is a long-time friend and Oracle ACE for OBIEE, so it should let us each showcase our respective experiences with Essbase and OBIEE in a completely non-marketing way.
  • CRUX (CRUD meets UX): Oracle Fusion Applications Functional UI Design Patterns in Oracle ADF.  This is in the Fusion track and I'll be talking about how to make a good user interface as part of the user experience of ADF.  No, this doesn't have a thing to do with Hyperion.
I am looking forward to all the wacky, new things Mike Riley (my replacement as Conference Chair for Kscope) has in store.  My first Kscope conference was in New Orleans in 2008 (back when they called it Kaleidoscope and no one was quite sure why it wasn't "i before e") so this is a homecoming of sorts albeit with 8 times as many sessions on Oracle BI/EPM.  If you're there (and let's face it, all the cool kids will be), stop by the interRel booth and say "hi."  It's the only 400 square feet booth, so it shouldn't be hard to find.

November 20, 2009

ODTUG Board - Elections

The elections are over for the ODTUG (Oracle Development Tools User Group) board of directors. Here are the new board members that will be serving in 2010-2011:
They join the carry-over board members who were serving in 2009-2010:
  • John Jeunette
  • Barbara Morris
  • Marc de Oliveira
  • Mike Riley
What the keen eyed among you will immediately notice is that Tim Tow was not re-elected. Apparently, it was a very close election and Tim fell just a couple of votes shy. Oracle EPM fans should not be totally disheartened, though, because Mark Rittman was newly elected. Mark is well known in the EPM/BI community. He will do a fine job representing the EPM/BI/Hyperion needs on the board. I've known Mark for a couple of years and I can vouch that he's a decent human being. (I refuse to be friends with anyone who kicks puppies or kittens. Well, okay, I'll be friends with them on Facebook but not IRL. Point is, Mark doesn't kick any small mammals.)

Tim Tow will serve out the rest of his term through December of this year. I know I speak for not only myself but the entire Hyperion community when I say, thank you, Tim, for all the hard work you've put into ODTUG. Hyperion developers, administrators, and users finally have a place to call home again, and it was your tireless service that helped get us there. Sincerely, we appreciate it.

If you want to say thank you to Tim as well, nothing says you appreciate his service like buying a copy of Dodeca from AppliedOLAP.

May 14, 2009

Brighton's Biggest Bi Event

Here's the brand-new shirt I got here in Brighton. Notice it even has my name on it:

When I decided to wear my shirt from the Rittman Mead BI Forum around Brighton last night, I was unaware of two things:
  1. "BI" means one thing to a techie and another thing entirely to the world at large.
  2. Brighton is home to the largest gay, lesbian, and transgendered community in England.

May 13, 2009

BI Forum in England

I'm here in sunny (well, rainy, to be honest) Brighton, England after a near 24-hour trip from Dallas, Texas. The view out my window is of the ocean (and both a carnival pier and a burned down pier) and it's stunningly beautiful. It's about 11:30PM here in Brighton, and my screwed up inner clock just woke me up for the day. Who needs jet lag: just wake up and go to sleep by your internal clock, time zones be damned.

I'm here to speak at an event Mark Rittman's company is putting on. They've invited people from around the world including some from as far away as
India and the United States (that'd be me from the USA). We're all going to be talking about Oracle EPM and BI. Though they do tend to skew more towards OBIEE and Oracle OLAP, there are two presentations on Essbase. I'm doing one on the inner workings of Essbase which is basically a "How Essbase Thinks" presentation but taken down to a slightly lower level due to the expert-level of the audience.

I'm looking forward to getting grilled during my session as the attendees play a rousing version of "Stump the Speaker." [Is it weird to look forward to that sort of thing? Discuss Edward's potential mental issues in the comments.] The schedule for the next two days is fairly comprehensive and includes speakers from Oracle as well as the partner community (and maybe a customer or two):

May 14

  • Craig Stewart : “Pure Oracle - New BI Applications with Oracle Data Integrator”
  • Edward Roske : “The Internal Workings of Essbase”
  • Mark Rittman : “Optimizing the Oracle BI Apps using Oracle Data Warehousing Features”
  • John Minkjan : “OBIEE Cache Management”
  • Venkat Janakiraman : “OBIEE and Essbase Security Integration”
  • Adam Bloom : “How to Blow Up the BI Server - A Case Study for Diagnosis of Performance Issues “
  • Andreas Nobbmann : “Scripting OBIEE - Is UDML and XML all you need?”

May 15

  • Mike Durran : “Oracle BI Roadmap & Strategy”
  • Emiel van Bockel : “OBIEE - The Rising Sun to Leave Stars and Snow Behind”
  • Daan Bakboord : “Oracle BI EE and Mapviewer”
  • Gerard Braat : “Understanding the Oracle BI EE Server Engine - Mastering the Random Request”
  • Adrian Ward : “OBIEE Global Implementations”
  • Antony Heljula : “Oracle BI & SOA Integration”
  • Peter Brink : “Integrating Cube Organized MVs into a Data Warehouse Environment”
If anything interesting comes up, I'll be sure to mention it. My presentation is in less than 12 hours, so now I just need to figure out if I should force my body to try to sleep or just stay up all night?

June 17, 2008

Kaleidoscope - Tuesday

11:30PM - Dinners
I had the interesting experience of having two dinners scheduled at the same time. interRel's client appreciation dinner started at 7:30PM at Bourbon House while the Oracle ACE dinner started at 8:00PM at Arnaud's. The two restaurants were about 2 blocks apart (small, Bourbon Street blocks filled with wanton debauchery) so I was able to start off at the interRel dinner for an hour, go to Arnaud's for an hour-and-a-half, and then make it back to Bourbon House to say good-bye to everyone.

There were about 45 people at the interRel event and roughly 40 at the ACE dinner. I had some decent vegetarian food at Bourbon House. I did notice that both restaurants liked to keep the wine glasses filled almost to the brim. I don't drink alcohol, but my tablemates more than made up for my teetotaling.

After dinner(s), 8 of the interRel folks went to Pat O' Brian's for hurricanes. They had a non-alcoholic version of the hurricane called the Eye of the Hurricane (get it?). It tasted like fruit punch mixed with pineapple juice. While I didn't get drunk, I got a sugar high and three cavities. Off to sleep before midnight!

7:00PM - Oracle ACE Panel and Reception
From 5-6, I attended an "Ask the Oracle ACE" panel. There were so many Oracle ACEs and ACE Directors that they took up the first 3 rows of the room. Literally, over half the people in the room were ACEs, so it turned into more of a Q&A from ACEs and less of questions for the ACEs. One of the more interesting questions was "once you're an ACE, how long do you get to be an ACE?" The answer was that Oracle ACE is pretty much a title for life since it's a honor based on what you've done. Oracle ACE Directors have to agree to do things to actively evangelize Oracle to retain their titles.

All of the ACE types then went up to the rather beautiful Armstrong Ballroom/atrium on the 8th floor of the Sheraton for a "Meet the ACE and ACE Directors Reception." They gave me some pimptastic Mardi Gras-style beads, but the beads were gold and silver Ace of Spades. I'm so tired that I wore the beads around for an hour without realizing the ace symbolism. I had to bug out of the reception after an hour to head up to the interRel hospitality suite reception leading up to the interRel dinner.

5:00PM - Java API and Custom Defined Functions
Tim Tow gave a presentation on the Java API. I really haven't used the Essbase Java API much (unlike the VB API) so I feel like I learned a lot. I couldn't say that I could go off and write the Java API with what I've learned, but I know where to start, at least.

I had 30 minutes to deliver my 46 slides on using Custom Defined Functions. I gave some examples of some cases where we've built CDFs for our clients including:
-Custom industry calculations (Weeks of Supply, for retail, for instance)
-JExport
-Statistical calculations (like the ones that come in the example files)
-Weather (yes, we pulled data from weather.com into a cube using a CDF)
-Relational database access (using a CDF to get data from a table into a dynamically calculated member)
-Advanced financial functions (we had a client once that replaced the @IRR() function embedded in Essbase with one that they felt calculated more accurately)

I admittedly went way too quickly. I actually finished the slides in 23 minutes and had time for a question or two. Tracy McMullen, Best Co-Author Ever, is giving a presentation immediately following mine on MaxL and Converting EssCMD to MaxL that I have to skip to head to the ACE panel. I'm sure Tracy will do a magnificent job.

3:00PM - VBA Toolkit and VB API
Lunch was not amazing: it was a plated meal with small servings. While it's nice to be waited on, I actually prefer buffets at these events, because I can eat at my own speed and get out of there.

They switched the order of Doug Bliss and Glenn Schwartzberg's presentations. Glenn's VB API presentation was moved to come after the presentation by Doug Bliss (from Ace Cash Express) on the VBA toolkits in the Essbase Spreadsheet Add-In and the Hyperion Smart View Add-In.

Doug's presentation had a few hiccups mostly due to audio/visual issues with his laptop. He had good content, but the audience seemed to feel it might have spent more time on "What is VBA" and not enough time on "Advanced VBA Toolkit Examples." There's only so much one can cover in 60 minutes and trying to satisfy all audience members at different levels is problematic.

Glenn Schwartzberg, Oracle ACE, gave the majority of the precreated VB API technology presentation with Tim Tow added color commentary. It's hard to make an API presentation interesting, but Glenn gave it his best. He had an interesting disclaimer slide that basically said don't trust anything he says because he's a rather shifty individual. I found the two of them to be entertaining.

They did the coding in VB6 but pointed out that the same code's usable in VBA. They did say that you shouldn't use the VB API inside of Visual Studio for VB.Net programming. They actually said you'd be better off using the C API inside of VB.Net. The real thing people should be using in .Net is HAB.Net which does have both a System 9 and an 11.1.1 version.

My Essbase CDF (Custom Defined Function) presentation is up next. I have 30 minutes to cover 46 slides!

11:30AM - Smart Space Gadgets with Visual Studio
Rob Hull save a presentation on how to build Smart Space gadgets in Visual Studio 2005. He started off with a brief demonstration of Smart Space (which is free to existing Hyperion users).

They've added a few new gadgets in Smart Space 11.1.1 to do a minor amount of Essbase administration. The list of gadgets now includes:
- Search
- Favorites
- Smart Book (web content and reports)
- Key Contacts
- Collaborator (instant messaging, if you will)
- Notification
- Essbase Calculations
- Essbase Data Loads

Rob spent about 30 minutes actually showing coding in Visual Studio 2005. He made it seem relatively easy if you're used to Visual Studio. For anyone interested in build Smart Space gadgets, there's an article on Oracle OTN:
www.oracle.com/technology/products/bi/epm/smart-space/community/first-gadget.html

Rob finished about 15 minutes early and turned it over to Tim Tow to show a couple of gadgets that Applied OLAP built. Tim showed an outline viewer that I think could be helpful. Tim also showed a an ad-hoc gadget that looks like Excel just through a Smart Space gadget. He had a prototype of a Planning gadget that links a Planning form to a spreadsheet directly in the same screen. His group built it in about a week, which shows that it's not that difficult to build one of these gadgets.

10:15AM - BI/DW/Essbase Experts Panel

I sat on a panel of Business Intelligence, Data Warehousing, and Hyperion experts:
- Edward Roske, interRel Consulting, Oracle ACE Director
- Jean-Pierre Dijcks, Oracle
- Tim Tow, Applied OLAP, Oracle ACE Director
- Mark Rittman, Rittman Mead Consulting, Oracle ACE Director
- Michael Armstrong-Smith, Armstrong-Smith Consulting, Oracle ACE

It was a rousing panel, because Mark is an Oracle OLAP guy, Michael is a legacy Oracle data warehouse guy, and Tim & I are Hyperion types. The first question was, with all of Oracle's acquisitions, what would recommend using to build a BI/EPM application today?

We were all relatively civil to each other, because we all like each other (although we're all fairly certain that our preferred technology is by far the best). Mark made an interesting comment at one point about how Essbase has a lot more energy surrounding it these days than Oracle OLAP has in recent years: "We've got 150 people in here supporting Essbase whereas most Oracle OLAP talks in recent years have been me and Dan Vlamis presenting to each other."

After the talk, I proposed a shoot out between an Essbase guru, an Oracle OLAP guru, and a Siebel Analytics "packaged BI app" guru. We'd all three try to build an Essbase sales analysis application in front of a crowd of people and see who finished first. Tim Tow felt that a wrestling match (battle royale?) would be simpler.

9:00AM - Calc Scripts: Beyond the Basics
I had a client status call from 8-8:45AM, so I missed the first 45 minutes of this presentation. When I came in, Ron Moore was covering methods for Essbase block creation (including lock & send, DATACOPY, and a few Essbase calc script settings). He then touched briefly on the new DATAEXPORT capabilities in Essbase 9.3x. What I saw of the presentation, I liked and I saw many 4's and 5's (out of 5) on the evaluation forms.

June 16, 2008

Kaleidoscope - Monday

10:00PM - Dinner
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 dimensionality
-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)
-Time intelligence
-Formula syntax
-Performance characteristics

Some gotchas:
-Planning
-Unit * Rate calculations
-Upper-level data load
-Custom functions

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 info@interrel.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":
  1. Move to the latest applications releases.
  2. Prepare a roadmap to evolve to Oracle Fusion applications.
  3. Inventory your enterprise assets.
  4. Rethink your "customization" strategy.
  5. Consolidate your master data.
  6. Embrace SOA-based integration.
  7. Extend your BI applications portfolio.
  8. Adopt enterprise reporting & publishing.
  9. Secure your global enterprise.
  10. Centralize your application's lifecycle management.
Robin opened it up for questions at the end. There was only one: "What direction is Oracle planning on taking with underlying databases feeding into Essbase like DB2, for instance?" Robin didn't know the answer specifically, but did say that Oracle's direction for Essbase was to sit on top of every source database they possibly could.

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.

April 17, 2008

Collaborate 08 - Mark Rittman's Blog

Mark Rittman has a very nice blog (he's quite the wordsmith) and since he's in Denver for Collaborate (flew over from the UK), he's blogging about Collaborate all week too. He attended my "How Essbase Thinks" presentation on Monday and he has for more interesting things to say about the presentation than I said during the presentation. My favorite quote was "The room was packed - around 170 at last count, with people standing at the sides and sitting in the aisle - which is about 160 more than the average Oracle OLAP talk in previous years." Interesting to see how much interest has fallen off for Express (Oracle OLAP) in the last few years. Mark was also surprised that I have a techy side, as he had previously marked me as a "business-type person." I think it was my "CEO" title that threw him.

Go to
http://www.rittmanmead.com/2008/04/15/collaborate08-day-1/ and check out Mark's Collaborate entries for yourself.

April 16, 2008

Collaborate 08 Hyperion Track - Wednesday

I got to sleep in until 8AM, because the first presentation I had to deliver was at 9:30AM on "Calc Scripts for Mere Mortals." The room was packed, but I'm not surprised: this one and "How Essbase Thinks" are usually really full.

In the continuing saga of disorganization at this conference, OAUG scheduled me to deliver two presentations at the same time today at 11AM: Ask an Essbase Guru and Tips for Hyperion Planning. Tracy is also supposed to sit on the panel, but she's delivering a presentation at that time too. We've been trying to convince them to move the Guru panel (in addition to the fact that I can't be both places at once, interRel has 3 other presentations at the exact same time). As of Wednesday morning at 8AM, they hadn't moved it, so we scrambled to get coverage. Josie Manzano end up delivering my Planning presentation and Vince Tran delivered Tracy's "Integrating System 9 with Your Data Warehouse" session. I heard afterwards from some of their attendees that they did great jobs.

The panel consisted of 7 of interRel's Hyperion Essbase Certified consultants (including Eduardo Quiroz, the co-founder of my company, and one of the first three Essbase certified consultants in the world). I played the MC role, and I really enjoyed it. We took questions from the audience (the room was about half full) and it's one of only three times in my life when I can recall not a single person walking out until time was up.

Some of the questions were high-level (how do you get Essbase certified?), some were forward-looking (what's going to happen with the Essbase VB API?), some were historical (what does the acronym 'Essbase' stand for?), some were technical (how do I get the Essbase Add-In to work for any user on a given computer not just the one under which it was installed?) and some were downright bizarre (when was the last time Edward shaved his beard?). We made it through about half the submitted questions and the audience gave the panel a nice round of applause at the end. I enjoyed the experience, and I think the attendees did to (since none walked out and they seemed to be smiling throughout).

The only problem was that although OAUG knew this was a panel, they only put one wired microphone in the room. They also didn't set up a raised table at the front (as we've had at previous panels). We ended up setting up 7 chairs for the panel, I used the microphone, and the panel tried to speak in their best "outside voice." There were a couple of times when Jason, Lisa, and Tracy couldn't be heard, so I had to do a bit of repeating (and one time Tracy walked around to the podium mic for a particularly long bit).

The organization of this conference compared to Hyperion Solutions (or OpenWorld which I did not enjoy from a content standpoint, but it was VERY well organized) is underwhelming. I've had several Hyperion attendees come up to me and when I ask "so how are you enjoying the conference?" either answer with "this is so poorly organized that I had to sit on the floor to eat my continental breakfast since they didn't provide tables or chairs" (or something about else about disorganization) or "there aren't a lot of good presentations." Some people have actually told me that they're not coming back to Collaborate due to its inferiority compared to Solutions. This isn't good, because where else are they going to go? There's Kaleidoscope for the technical side, but they don't (at least at the moment, anyway) offer applications content.

... and they have to do something about the food. I know I'm beating a dead horse (and on a related note, some of the attendees feel like at lunch they've been eating a dead horse), but food is important. People have to eat every single day, and they don't expect to be out of town eating bready sandwiches. May I add that I'm also appalled that you have to submit a ticket to get food (and one drink only!) at lunch? We're all wearing our badges, so the only reason to have us also give tickets is to make sure that we're not getting seconds. In other words, they want the people who are still hungry after their sandwich to stay hungry. They also limit each attendee to two drinks during the Wednesday night event which they monitor through tickets. Two drink maximum? That's reason enough to boycott right there.

I think someone from Collaborate must have read my blog, because they actually served a hot lunch today! I was told it was a buffet style lunch with actual warm food. I saw someone eating steak and someone else with salmon. As luck would have it, I was at my second book signing today, so I wasn't able to find out if there were any hot vegetarian options. Danielle was kind enough to run over to the Hyatt Altitude restaurant and pick me up a quesadilla. My stomach was most appreciative. Today's book signing was more lively than yesterday. The bookstore sold out of our System 9 books but they have plenty of Essbase 7.1.x books left. I wonder if the adoption rate of System 9 is accelerating or if people just hate to learn outdated information?

The book signing overlapped into the OAUG Meeting of the Members in the Wells Fargo Theater. I dragged Tracy over there with me. We sat high in the balcony and ate our warmish lunch. When we walked in, OAUG was talking about their new Web 2.0 application: Knowledge Factory. It lets users share information with other users and there's a bit of social networking as well. While this seems nice, isn't this already being done by Blogger, MySpace, and Wikipedia? Maybe it's better simply because it's not opened up to everyone but rather exclusive for OAUG members? I doubt it, but we'll see.

They asked all the Oracle ACEs to stand, so I did, but I was in the back row, so I think only Tracy saw me. She gave me a pity clap. Most of the meeting (from the point where we walked in) was devoted to giving out awards. Tracy left about 10 minutes after we arrived, and I really can't say I blame her. I stuck it out, though, in the hopes of quality information. There was none.

After the Meeting of the Members, I had a 90 minute talk with Kristin Newman about the future of the OAUG Hyperion SIG. She asked me to "please not blog" about the contents of our conversation, so I'll respect her wishes. I'll see if Ed Delise (President of the OAUG Hyperion SIG) wants to put anything on the record.

I stopped by the booth to help with the packing away of everything. They would only trust me to handle taping of the boxes. I did a few and then Val decided I was unworthy and took my tape gun away. I did convince one of the exhibit hall cleaning people to let me have one of the interRel blue dog prints (the ones that led the way to our booth); it's proudly adorning my laptop bag at the moment.

I went to dinner at Baur's with the ODTUG board of directors and a few others (Tim Tow, Mark Rittman, Dan Vlamis). Dinner was pleasant. For dessert, I ordered chocolate gelato (I'm a big fan of gelato) and they brought me 4 balls of gelato... each the size of a marble. Literally, they were less than a bite full. Everyone else's dessert was huge, so I got seriously mocked. It got even more ridiculous when the waiter brought out cones of cappuccino ice cream compliments of the house each one of which was bigger than my four marbles of gelato put together. I asked Mark Rittman to take a picture of my dessert just so I could show how unbelievably small it was. My advice if you're eating at Baur's in Denver: don't order the gelato.

Did I mention that it started snowing? It was 70 degrees last night and now the ground is covered in a layer of wet snow.

I was supposed to go to the "Explore Colorado Party," but several of my friends stopped me as I was about to go in and warned me not to bother. They claimed that there was some indoor skiing (on a carpet?) and inflatable rock climbing. While it sounded like it could have been fun, I do have some blogging to catch up on. Tomorrow's the last day, and I can't hardly wait!