Hyperion & stuff

Stuff about Hyperion and stuff

OBIEE Essbase relational drillthrough

Wow.  I still can’t believe that I did this one.  We had a new requirement to create an HR cube and drill down to employee levels for more details.  I had thought of using Hybrid Analysis in EIS, but that means the cube will be totally dependent on EIS.  So I decided to use the “vertical” federation of OBIEE data model.  The employee level will exist on relational DB while other levels are on Essbase.

I used this Oracle by Example to get an idea on how to accomplish this: Federating Essbase and Relational Data Sources in Oracle Business Intelligence Suite Enterprise Edition Plus. Pretty helpful.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: