It has been a while since I published Part 1 of the Essbase Studio Tutorial by Example. Finally a quick follow-up to the original that I promised I would get out - a  second part on adding drill-through capability - is available.  This document has been sitting around for a while.  I’ve been swamped and with the not too long ago release of EPM 11.1.2 I wanted to at least get this document out while it is still relevant.

If you haven’t already, please read the full OTN article here as a pre-requisite to conducting part 2 of this tutorial series.

Please see the link towards the bottom of this post to download part 2 of the tutorial (PDF).

Let me know if you have any feedback.

Download

Essbase Studio Tutorial by Example Part 2

Pre-Requisites / References

http://www.oracle.com/technology/pub/articles/screen-essbasestudio.html

Whether you are a user or implementer of Smart View there comes a time when an upgrade is necessary. Since each user installs the smart view binaries on their workstation/laptop, the question of how to push a system-wide upgrade may arise. Fortunately this functionality is built into Essbase Administration Services.
Read the full story

Sometimes I feel like I am the only evangelist out there for Essbase Studio and I wonder why that is since Essbase Studio is such a great tool.  This is especially true when you look at its ability to connect to a myriad of data source such as OBIEE, Teradata, MySQL, EPMA Dimension Server, netezza, etc.  Below is the top 10 list of why an organization should migrate their existing Essbase Integration Services models to Essbase Studio.  If your team is not an early adopter, run it in parallel.  If your team is scared of change, have them read “Who Moved My Cheese?“.  Otherwise, let’s make it happen.  Get with the program and enjoy the fruits of this fantastic toolset made for those who believe analytics are always evolving for the better.

Top 10 List

10. It has a familiar feel to EIS but its actually intuitive and user friendly.

9. It integrates with the new features of Essbase Server 11x.  Has EIS been touched since System 9x?

8. Introspection

7. There is a step-by-step tutorial on Essbase Studio Server made just for you (here).

6. Security provisioning and roles can be assigned in Shared Services.  Deliniate data modelers from administrators.

5. Essbase Integration Services is about to get sunset and Oracle Support will go bye-bye.

4. It connects to EPMA Dimension Server out-of-the-box. Ever heard of Master Data Management?

3. Essbase Studio Models are deployable with native MaXL Scripting.  Have you tried to automate a EIS deployment?

2. Essbase Studio comes with an Integration Services Catalog Migration Wizard. (hint, hint)

1. Larry Ellison wants you to.  Seriously, Oracle’s BI roadmap is taking Studio to the next frontier, not EIS.  Its a good train…get on it.

ASO does not provide an out-of-the-box version of dynamic-time-series (DTS) like its partner in crime, BSO. However, one straightforward approach to achieving this functionality is to implement a time aggregation dimension and leverage MDX functionality.  In this example we will house the Time Periods/Months (i.e.:  Mar, Apr, May, etc.) and the Years dimensions into two separate dimensions.  We then add an additional dimension called “Time Series” to the outline to support our ASO version of DTS.

Read the full story

By now every knows that the release of Hyperion 11x has provided us with the latest and greatest Essbase modeling application, Essbase Studio.  A lot of us are familiar with Essbase Integration Services and have been looking at Essbase Studio like a two-headed dog.  They either are scared and don’t want to go near it or they are so used to their purse-dog, i.e: EIS, that they stick with what they know best and haven’t unwrapped Essbase Studio yet.

This blog post should put and end to any reluctancy.  I introduce to you the first Essbase Studio tutorial on the web. 

You can download the PDF here. (I’ll eventually move this to a CDN if the downloads get to big, so please link to this post and not the document itself.)

Hyperion Essbase Studio Tutorial by Example (PDF)

I am also breaking the tutorial into a series with this being part 1.  There are a lot of cool new functions with Essbase Studio and you will immediately see the benefits it has over EIS. Soon, you’ll see other blog post here on Essbase Studio tutorials part 2, 3, etc. so be sure to check back often or subscribe to the RSS.

If this series is good, bad, or indifferent please let me know.  I would like to keep these up and with your feedback I can revise and make the documents that much more informative everyone.

Cheers.

Update 8/30/2009

- This should have been posted to the live site last week. I am in the middle of switching hosting providers for my blog and uploaded this post to my test site instead of this one. Sorry for the delay.