BOBJ BI 4.0 SP04 Patch9 SSO/BICS OLAP broke
1. BOBJ BI 4.0 SP04 ** on AIX 6.1 OS
Includes APP tier and separate WEB tier running tomcat (again on AIX 6.1)
Oracle 184.108.40.206 DB (again on AIX 6.1)
2. BW 7.3 (latest patches as of last month) ** on AIX 6.1 OS and oracle 220.127.116.11
3. Windows PCs running either XP (professional SP3) or Windows7 (enterprise SP1)
with BOBJ Client Tools BI 4.0 SP04
with BOBJ LIVE OFFICE BI 4.0 SP04
with Dashboards 4.0 SP04
4. We have SSO up and running using our LDAP (Microsoft AD) all the way through to our BW back-end.
In other words, we can launch the PC IDT using LDAP credentials, then get to the BOBJ server and from there, create OLAP connections via BICs to get to the BW cubes. No problems.
We were on BI 4.0 SP04 Patch 3 for BOTH the AIX BOBJ server and the PCs running either XP or Windows 7.
Again, no problems, we were happy.
WE moved to SP04 PATCH 9 for BOTH AIX BOBJ server and the PC tools.
Now, we can no longer create new OLAP connections in the IDT using SSO. By that, I mean, you can “create connection”, select BICS, say “use SSO”, put in the basic BW info like SID, hostname, instance, but when clicking “Next” to see the back-end BW cubes, there is nothing that shows up. Normally, you would see a list of folders and at that point you could search for your cube.
We don’t see anything, it is just blank. No error or anything.
We CAN still use our BW username/pass and create OLAP connections that way. So we can reach the BW system via above scenario only if we put our BW credentials in when building the OLAP connection.
We cannot view the cube information on any previously built OLAP connection, if it was built using SSO. Again, it just comes up blank when looking for the backend BW info.
Furthermore, if I back-out the Patch9 on the PC only (go back to Patch3 for client tools, live office, etc), we are OK! everything works!
SSO works, I can view the cubes for previously built OLAP/bics connections, etc.
Anyway, I have been going back/forth with SAP on this issue for over a week. I keep getting bounced to different groups like the ADM or SL. Crazy.
Anyway, does anyone out there have any thoughts?