Showing posts with label Tim Tow. Show all posts
Showing posts with label Tim Tow. Show all posts

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 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.

September 29, 2008

OLAP Underground - Utilities are Back

Thanks to the Tim Tow and the other good folks over at Applied OLAP, the two most popular OLAP Underground Essbase utilities are back and they've been updated to work with Essbase versions 6-11 (and they're free!). For those of you who haven't been around Essbase for too many years to count and have never heard of them, OLAP Underground was a group of anonymous Essbase programmers who built utilities to handle the things they did a lot that Essbase didn't do at all (or very well). OLAP Underground was then nice enough to give them away.

After a brief sabbatical to get the code updated to the newest versions of Essbase, two of my favorite utilities are back.

The most popular of their applications was called the "Outline Extractor" and it, well, it extracted outlines to text files. Since Essbase would let you extract an entire outline but in a completely useless format, the Outline Extractor became everyone's favorite "dimension export" tool.

You could export one dimension at a time or all the dimensions at once and you could pick which fields you wanted to export. There was a Windows thick client as well as a command-line so export tasks could be scheduled. Here's the link to the page with the Outline Extractor:

Now of course there are much better tools nowadays for exporting dimensions, but if you need a quick and dirty text export of one or more dimensions, this is the tool for you.

The other hugely popular OLAP Underground utility was called the "Advanced Security Manager." It's a tool for managing Essbase security even across servers. Even in the days of EAS and Shared Services, it's still hugely useful for exporting security to text files (or importing from text files). Like the Outline Extractor, the Advanced Security Manager also has a command-line for scheduling security updates. Here's the link for the Advanced Security Manager:

Thank you to Applied OLAP (an interRel partner) for updating and hosting these utilities. If you have a minute, send Tim Tow a quick "thank you" (which is best expressed in the form of a Pay Pal money transfer to his personal account). Also note that while Applied OLAP is hosting these applications, they're not officially supporting them. This means that you're on your own if you have questions or things break.

June 30, 2008

Tim Tow Joins ODTUG Board of Directors

I just saw a press release on the ODTUG site announcing that Tim Tow has just been elected to the ODTUG Board of Directors. With Oracle directing the Hyperion development community to ODTUG, Tim's addition makes a nice statement that ODTUG is serious about their commitment to Essbase and the rest of the Hyperion world.

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.

May 28, 2008

Oracle ACE Program

Somebody asked me about the Oracle ACE program that I mentioned briefly in another blog entry. It's basically a title that Oracle awards to dedicated Oracle evangelists. If you eat/breathe/sleep Oracle and spend most of your free time helping other people understand how great Oracle is, you might get nominated to be an Oracle ACE. Once you get nominated, there's a selection committee that looks into your background to make sure you do things like post regularly on discussion forums, write books, make blog entries, give public presentations on Oracle, name your first child Ellison and so forth. In other words, Oracle ACEs are the gurus in their fields of expertise. If you see the Oracle ACE icon next to someone's name on the Oracle forums, they most likely know what they're talking about.

There is a further distinction above and beyond just the Oracle ACE level, and that's an Oracle ACE Director. While an Oracle ACE is a recognition of past achievements, you have to commit to future preaching of the Oracle gospel to become an ACE Director. Fewer than one in three Oracle ACEs becomes an Oracle ACE Director (there's a separate nomination you have to go through to get to this level).

At the time of this writing, there are ~175 Oracle ACEs in the world of which ~50 are ACE Directors. Of those, 6 are in the BI/EPM field and of those six, 4 are in the Hyperion space:
Glenn, Tim, and Gary all post far more in the OTN forums than I do. (I tend to do mass-communications like webcasts, books, blogs, and presentations.) Look for them particularly on the Essbase forum. and on Network54's Essbase site. All four of us will be presenting at Kaleidoscope as well, so you'll be able to meet them in New Orleans. Across all of the tracks, there will be 31 Oracle ACEs and ACE Directors presenting at Kaleidoscope.

Oh, I guess while I'm on the subject of Kaleidoscope, I should point out that as of today, there are only spots left for 18 more attendees in the Hyperion track. If you've been meaning to sign up for the best Essbase training you'll see in 2008, I'd hurry and click here (or forward the link on to the Essbase admin or developer at your company):