|gerdpee on Dimension does not contain any…|
|jasmine on Dimension does not contain any…|
|gerdpee on Oracle WebLogic and Hyperion S…|
|OBIEEfan on Oracle WebLogic and Hyperion S…|
Stuff about Hyperion and stuff
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.
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.
OBIEE 11g, Essbase 18.104.22.168
After installing OBIEE 11g on my Windows XP laptop which runs Essbase 22.214.171.124, I found out that the Oracle BI admin tool was unable to connect to the installed version of Essbase. After a bit of research, I found out that OBIEE 11g will only run with the included Essbase 11.1.2 version client. This caused a problem on my machine since all Essbase environment variables on my machines are pointing to version 126.96.36.199. My workaround for this is by creating a separate batch file to start the Oracle BI admin tool as pasted below.
C:\WINDOWS\system32\cmd.exe “/cc:\OBIEE\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd coreapplication_obis1 2 && c:\OBIEE\Oracle_BI1\bifoundation\server\bin\AdminTool.exe”
Now my Admin Tool can connect to the installed Essbase.