Stepping away from the back-end of OBI 11g for a minute, I wanted to show one of the features of OBI that has just moved slightly to a different location that where it existed in 10g.  Seemingly in OBI 11g there a few features that look to be hidden just by the way the new prompts, wizards, or drop-downs are created.  Without looking deeply you just might miss them.  But this post isn’t about uncovering all the clandestine gems of OBI, it is simply to provide a tutorial for how to create an Analysis query filtered by a column on the results of an existing query.  I’ll let you determine for yourself where this may solve a use case and wield its power for your future development goals/requirements.

Get Started

This tutorial uses the SampleApp web catalog and metadata provided by Oracle which can be downloaded on Oracle’s BI portion of their website.

Here are the steps…
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.

Update 11/26/2010

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