The ArtOfBI.com Newsletter

Is stupid new and freshly informative on BI and EPM.

Save one little gremlin by not pouring water on its head.

Or, sign up for killer tips, tricks and other BI / EPM goodness delivered right to your inbox.

Hell just do both. Enter your email below.

Oh no what happened?
I already signed up.

BTW, Signing up gets rid of this annoying banner.

Cheers,
Christian & The ArtOfBi.com Team

Essbase Studio Tutorial by Example

Posted on 27 August 2009
Tags: By Example, Essbase model, Essbase Studio, Schema, Tutorials

  • Sharebar

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.

Update 11/26/2010

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

###

«
»
Comments:
  • http://www.artofbi.com/index.php/2009/11/top-10-reasons-to-migrate-integration-services-to-essbase-studio/ Top 10 Reasons to Migrate Integration Services to Essbase Studio | Art of Business Intelligence

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

  • Michelle

    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?

  • Avishek

    Can I build one single dimension from multiple sources in Studio?

  • Guest

    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.

  • http://intensedebate.com/people/aakhan06 aakhan06

    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.

  • Mihai

    Does anybody know how you can add a new column to a data source connection in Studio?

  • sivasai

    Hello Christian,

    I read your article in OTN website about Essbase studio. It was excellent.

    Please share the SQL files that you used in the lab and any other Studio Tutorials ..

    Please send to mail id valmiki.sivasai@gmail.com

    Thanks!
    Siva.

  • http://intensedebate.com/people/ChristianScreen ChristianScreen

    Siva,

    Here is the link to the original MS data files http://msftdbprodsamples.codeplex.com/releases/vi...

    For the OTN article I adjusted that dataset to be Oracle friendly and that data can be downloaded from http://www.artofbi.com/tutorials/oracle_essbase_s...

    Cheers,
    Christian

  • Don

    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.

  • http://intensedebate.com/people/ChristianScreen ChristianScreen

    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.

  • Don

    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.

  • http://intensedebate.com/people/ChristianScreen ChristianScreen

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

  • http://www.itcoworld.com/ Lucinda Peery

    Cool, Of course,what a great site and informative posts,I will add backlink – bookmark this site? Regards,Reader. :-D

  • P B

    Looks like its a direct copy from Oracle website – embellished with some sql server installation procedure..

    Original article here –
    http://www.oracle.com/technology/pub/articles/scr...

  • http://intensedebate.com/people/ChristianScreen ChristianScreen

    PB,

    Yes, I am one in the same author.

  • http://www.artofbi.com/index.php/2010/08/essbase-studio-tutorial-by-example-part-2/ Essbase Studio Tutorial by Example – Part 2 | Art of Business Intelligence

    [...] has been a while since I published the Part 1 of Essbase Studio Tutorial by Example. Finally a quick follow-up to the original that I promised I would get out – a

  • bees

    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

  • ChristianScreen

    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.

  • acha

    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.

  • praveen

    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.

    Thanks,
    Praveen

  • Ugo

    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?

    Ugo

  • PD

    Cube deployment is not building Shared Members…any tips on how to get that going???

Recent Posts