Doing some Essbase / Oracle BI 11g integration lately, I actually decided to read one of the prompts from the 11.1.2 release of the Oracle Essbase Administration Console. Don’t get me wrong. I am a big fan of language and linguistics. I enjoy reading FAZ as much as the WSJ. I often misspell words when typing to quikkly. However, I usually pay greater attention to detail when someone is paying me to write. So when I saw this incorrect sentence in EAS I couldn’t help but get a bit nastalgic for the good old early console gaming error and the now pulp techy saying, “All your base are belong to us“. This seemed to me the perfect Essbase twist on that saying.
I’m envisioning T-Shirts at Oracle Open World, hats, bumper stickers and the like. I think even Edward Roske will want to use this title in the next book of his Essbase series.
And just so that you are not in the dark or left empty by this quip, allow me to leave you with a short video of show what the heck I am referring to. As if you aren’t techy enough to know already. : )
Oracle by Example has released a great tutorial on integrating Oracle Essbase 11.1.2.1 with OBIEE 11g.
This is a fairly straightforward integration delivered in OBE fashion as they do a bang-up job with screenshots and base explanations. It should take around 45-Minutes to complete the exercise with all required systems started and ready to go.
In this OBE, you learn how to connect to the Administration Tool, import the Essbase BISAMPLE cube into the Physical layer of the repository, build the Business Model and the Subject area, and create analyses from the objects in the Subject area.
With the aim to provide a fabulous integration between Oracle BI/EPM, i.e.: OBIEE and Oracle Essbase / HFM , etc Oracle has made some wonderful strides. OBIEE 11g is a testament to that integration’s roadmap. This post is all about just getting OBIEE 11g configured for interaction with Oracle Hyperion Essbase as close to right out of the box as possible. Although the Essbase integration doesn’t completely work directly OOTB, Oracle has at least set the stage for the infrastructure. What do I mean by that? Let me explain.
OOTB the Oracle BI 11g instance already installs/contains the following items for integration with Oracle Essbase 11.1.2:
Essbase JAPI files
Essbase C API files
What is missing for this OOTB Oracle Essbase integration is:
Configuration of PATH variables pointing to the location of the Essbase API files
Configuration of the Administration Tool to know where to point for the Essbase API files
Oracle BI Server (now managed by OPMN) to know where to point to the Essbase API files
Actually this is done OOTB but one will want to confirm the location is indeed set propertly
This has to do with the machine where the OBI Server itself is installed and is not an issue if just running the OBIEE 11g Client Tools
My name is Christian Screen, a Business Intelligence mastermind working with mainly Oracle and Microsoft technologies. The views expressed here are my own and do not reflect the views of Oracle, Microsoft, or my employer.
