Integration (sort-of) of OBIEE 188.8.131.52 and Hyperion Shared Services 184.108.40.206
June 17, 2011
Posted by on
Since we’re doing a major upgrade on the whole Hyperion hardware, I was exploring to upgrade our current OBIEE 10 to 11. However, I can’t seem to find any docs on how to integrate OBIEE 11g with our Hyperion Shared Services 220.127.116.11. Apparently only Hyperion 11.1.2.x is supported in this version of OBIEE. So, I had to find a workaround to get all the HSS users to authenticate with OBIEE. Since all of our users and groups are native users, it was possible to connect OBIEE directly with HSS OpenLDAP. I got this solution PARTIALLY working (I’m so happy about it). I managed to bring in all the HSS users AND authenticate OBIEE with HSS. The sad thing is there’s a lot more customizations to be done to bring in all the groups. So, I decided to scrap OBIEE 11 and went back to 10.
Here’s how I did it
- From OBIEE Administration, open the RPD, select Manage->Identity from the Menu and add a new LDAP server.
- Specify the Name of the server (anything you want).
- Specify the Host Name where HSS is installed.
- The default port number of HSS 18.104.22.168 is 28089
- Base DN is path to tree where users are under. Base DN is ou=People,dc=css,dc=hyperion,dc=com
- Bind DN is how we connect to OpenLDAP. Bind DN is cn=root,dc=css,dc=hyperion,dc=com
- The default Bind password is security
- Switch to the General tab and change User Name attribute type to cssDisplayNameDefault. The Automatically generated text box needs to be unchecked.
- Click Test Connection to verify the OpenLDAP connection.
- Now create a new initialization variable for the LDAP server. Select Manage->Variables from menu.
- Specify the name of the new Initialization block.
- Click Edit Data Source, select LDAP as Data Source Type and select the new LDAP server created above. Click OK.
- Click Edit Data Target and add a new variable called USER. There will be a warning and stuff, but just continue.
- Once created, modify the Mapped Variable to cssDisplayNameDefault. Click OK to save.
- Now we can test the connectivity. Click Edit Data Source. Now the Test button should be enabled. Click it.
- Enter any valid HSS user and password. Click OK. If everything is good, it should return with Results with Variable = cssDisplayNameDefault and Value = the specified username. Click Close.
- Restart everything and HSS users should authenticate against OBIEE (I hope).