Art of BI: Essbase Studio Tutorial by Example

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.


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.

Update 11/26/2010

Oracle Technology Network move the link to the published article, here.

Update 07/08/2013

Here is the 2nd part in this series for Drill-Through in Essbase Studio

Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).

24 thoughts on “Art of BI: Essbase Studio Tutorial by Example”
  1. Thanks Christian, I really like your site and I found the tutorial very useful. It didn't answer one of my questions however, how do you get the data source created in Studio to pick up any changes in your source database – surely this must be possible?

  2. Hello Christian,

    Thanks for putting such a great resource. I also wanted to know about free demo products if any available to test it out. I heard that Oracle Hyperion provides free demo version to use at home or work to get to know the product, is this ture. if that is true could you please provide a link to the website where we can download the software…….I dont have EIS at work so , i was thinking if i could have the advantage of lerning through your documents.

    i reall appriciate your help.

  3. Nice writeup christian. We dont have EIS, infact I really wanted to learn this tool. Your document is really good if someone wants to learn. keep up with good work christian.

      1. Chris, Thanks alot for the step by step guide, this is really helpful for newbie like me. However I got "#Missing" in my spreadsheet when Retrieve the data. Any idea why, I double check against step by step guide and could not find anyting I miss.

        Also When I preview data from EAS, I got "Duplicate Member names within data preview are not currently supported.

      2. Don,

        I would have to see part of your development efforts to troubleshoot your issue. I suspect since you are seeing #missing that you have not run the CALC on the cube and your data is not yet aggregated. Since you are able to pull up the cube in Excel and can see the #missing you clearly have built the cube successfully. Just run the CALC and I believe you should be good to go.

      3. Hi Chris,

        Thanks for replying. Yes, I actually right click on my AW db from EAS, choose "Execute Database Calculation" with "default" Calc. It executes without any error. But I still got #Missing from Excel.

        Any pointer so I can check where I miss?

        Thanks again.

      4. Don,
        Take a look at bot the Essbase studio and Essbase log files. This may give you an indication to where your problem lies.
        Check your relational fact table to ensure that there is data in there.
        Also, make sure that you are pulling "All" data from your MS Excel query so that you are not filtering on any specific dimensional member(s).

      5. I think I know what the problem is, check the mini schema. In mine there are 3 columns in the Fact Internet Sales joins to the DimTime table. After I removed the other 2 joins. It works fine. I only use the OrderDateKey to join to the TimeKey in the DimTime table.

  4. Hi Chris,

    I am trying your tutorial in EPM112 instance on Windows 2003 server. I have followed instructions as per your tutorial but I get the below error while deploying the Cube Schema:
    ember load for dimension Product started at: Fri Oct 29 14:33:22 BST 2010. Member load elapsed time: 7 Seconds.

    Failed to deploy Essbase cube.
    Caused by: Failed to build Essbase cube dimension: (Product) .
    Caused by: Cannot get async process state. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information

    Any idea what it could be? appreciate your comments

    1. Bees,

      The tutorial is not vetted fully for EPM 11.1.2 although it should still work theoretically. In previous replies someone noticed that with SQL Server there was a need to reduce the length of the column names for the product dimension table(s) that I have shown in the tutorial. Once they rebuilt the table and other logic with reduced column name sizes their issues went away. Its a bit of extra work on your end for the tutorial but give that a try.

    2. Hi Chris,
      I've the same problem in doploy the cube:
      Caused by: Failed to build Essbase cube dimension: (Product) .
      Caused by: Cannot get async process state. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information

      Any ideas?


  5. Hi Chris,

    Thanks much for your write up. This is helpmed in a good way to understand. Could you please let me know if Essbase Studio supports Parent Child build method or Only Level build method.


  6. Thanks very much for the tutorial. I just used it successfully with Oracle Essbase and the MSSQL 2012 Adventure Works DW database. Adventure Works is almost unchanged with DimTime table now named DimDate. Essbase appears to have changed a bit more especially with expanded Cube Deployment options. Nice job!