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.

http://www.oracle.com/webfolder/technetwork/tutorials/obe/hyp/OBIEE11g-Essbase/index.htm

Oracle By Example Exercise Overview

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.

Recently a client was attempting to install Hyperion 11.1.1.3 in a secondary environment and bumped into the issue that HBR was not registering with Shared Services.  The configuration would complete but of course with a yellow warning icon on the HSS configuration portion of the wizard.  When opening Shared Services she could see HBR in the application group but it did not appear within the Roles selection for provisioning.

The fix for this was actually very non-intuitive.  No matter how we initially attempted to solve the problem head-on the problem persisted.  We clamped deeply to the idea to not delete the current installation since all other components install correctly.  No one else had the full blown solution but one Oracle forums thread go us close.

What fixed it for my client was to:

1. Delete the Sample Planning Application completely as this was created just to see if by creating a Sample Planning Application would make the HBR situation resolve itself. : )
2. Open Microsoft Word from any remote machine
   File -> Open -> http://[HSS_Server]:58080/interop/content/files/Products/
   Login as the native admin user
   Right click HBR-9.3.1.0 and delete.
3. Stop Planning Services
4. Stop Workspace
5. Reconfigure Shared Services (Foundation) and Deploy to Web Application
   • Wait for this to complete before running the next step
6. Reconfigure EAS and Provider Services and Deploy to Web Application
7. Restart the services even if they are already restarted after the reconfiguration

References

John Goodwin’s tactic found in a reply on Oracle forums helped get us partly to the full solution.

Is there a right way to architect a Hyperion EPM infrastructure?  I think the answer to that is yes, and when provided with some straightforward examples, and architectural guidelines by the software creator themselves, Oracle, we can at least gain some semblance of what that looks like.

I tracked these down a while ago and I am posting them here for reference but I also thought that others might find these documents useful.  If not for actual architectural layout and planning, the images contained there-in are definitely helpful for your next presentation slide deck.
Read the full story