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.
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?
Can I build one single dimension from multiple sources in Studio?
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.
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.
Does anybody know how you can add a new column to a data source connection in Studio?
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.
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
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.
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.
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.
Cool, Of course,what a great site and informative posts,I will add backlink – bookmark this site? Regards,Reader.
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...
PB,
Yes, I am one in the same author.
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).