Hyperion & stuff

Stuff about Hyperion and stuff

Monthly Archives: April 2011

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.


OBIEE – Workspace SSO

I can’t believe how frustrating it is to get OBIEE Workspace SSO to work in OAS installations.  If I didn’t remove the two lines in mod_oc4j.conf, OBIEE won’t even show up under Workspace Applications.  However, I suspect it’s got something to do with that bips thing.  Gotta keep looking into this.

Anyhow, getting this thing to work in Tomcat turned out to be quite easy.  Took me only 1/2  a day to get everything to work.  So the docs was good.