Tag Archives: essbase

it is the season for learning

With summer arriving, up north, it means the opportunities for meeting and learning from Hyperion users is among us.

The UK folks have the OUG EPM & Hyperion conference this week, with a full packed agenda covering a range of Hyperion topics as well as OBIEE for those wondering where the future lies.  This will be my first year since 2006, when I’ll miss the conference, now that I’m based in the US.

So me highlights for me include AMOSCA’s session on “Unravelling the EPM spaghetti” and Edward Roske – always a great speaker with lot of tips and tricks to share crammed into his sessions.

But there’s plenty of action stateside happening too, thanks to the OAUG:

OAUG Connection Point – R12.1, July 12-13, Chicago.

OAUG Connection Point – EPM/BI, July 20-21, Seattle.

OAUG Connection Point – EPM/BI Nov 15-16, Atlanta.

For me the Seattle conference, presented by OAUG, Northwest Oracle User Group, OAUG Hyperion SIG and OAUG BI SIG, has added significance since it’ll be my first presentation in the US:

  • “Why Data Visualization is Important in Delivering Actionable Insight”

Helping business users gain insight and enabling them to do their jobs better has always been a key component in my work ethic, I look forward to sharing and learning from the other participant and speakers.

So take advantage of these great opportunities and I hope to see some of you soon.

BOOTNOTE:  I forgot the Oracle Development Tools User Group event Kascope11 which is later this month from 26-30 June 2011, held in Long Beach California.



essbase on solaris – are you mad?

Several years ago Sun began a project to update and consolidate the business intelligence tools used at Sun and we decided on Hyperion as we had a variety of Hyperion tools already: Brio, Essbase.  This was a few years before the Oracle acquisition of Hyperion and we wanted to run on Solaris.

This meant we were one of the first customers to run the Hyperion suite on Solaris and I frequently had conversations with other Hyperion experts similar to the title of this post and was also told that Essbase was designed on windows and would therefore run best on windows.

While the original implementation had it’s difficulties being one of the first on Sun hardware, software and operating system it undoubtedly laid the groundwork for the recent Hyperion Essbase ASO World Record on Sun SPARC Enterprise M5000.

The Oracle Essbase Aggregate Storage application employed for the benchmark was based on a real customer application in financial industry with 13 Million members in the customer dimension.

The benchmark system was a M5000 server with 4 UltraSPARC64 Vii 2.53 Ghz (quad core) and 64Gb ram running Solaris 10 update 8 and Oracle Essbase (64 bit) combined with a Sun Storage F5100 Flash Array consisting of 40 x 22 GB flash modules in a single zpool.

The benchmark compared 500 and 20,000 users and showed that usage based aggregation improved response times, while adding the extra users showed similar performance with no signs of degradation in query timings.

What is interesting in the benchmark is that this seems to be one of the first to combine a variety of Oracle technology and provide a benchmark for John Fowler to beat:  Solaris ZFS, SPARC M9000 server, Storage F5100 Flash Array and Essbase.

For more information check out the whitepaper here(pdf), Note: the BestPerf blog has an incorrect link since the recent update to the Oracle Technology Network.  More details on Hyperion applications here.

Essbase and Reporting SIG

Here are some notes from the recent Essbase and Reporting Special Interest Group event held in London recently:

The Essbase SIG was held in conjunction with the Planning SIG as there’s quite a bit of overlap between products and uses.  It’s always difficult to plan these events to cater for all and manage to avoid the "Ugh, I want to go to both sessions at 2pm" comments.  We did combine two sessions on:

Application and Infrastructure benefits of upgrading to version 11.1.1 

This was presented by Peter Hill, Jane Story and Adrian Weston from Oracle and covered a wide range of items and was very well received by attendees.  The format also allowed for several questions from the audience and added to the understanding.

 Shared Services 

This was presented by Jake Smillie from Altius Consulting, who was filling in at the last minute.  Again this was a very informative session covering many aspects of security, groups and authentication.

The remaining sessions covered a wide range of topics: 

  • Tips and Tricks for Reporting and Essbase
  • Canon UK customer presentation on essbase implementation/migration
  • Product enhancement requests – the SIGs at as focal points for users to present issues and product enhancements to members who attend the Oracle Customer Advisory Board meetings.

A special thanks to the presenters and to everyone who took part and participated.  The events reflect the diverse user community and enthusiastic members we have.

All presentations are available to download for UKOUG members only from the website

Anyone interested in joining the Oracle User Group or having a say in the future direction of the SIGs can find more information on the main website: http://www.ukoug.org