SSO with Analysis for Office using OLAP on BI LaunchPad?
I have learned a lot about Analysis for Office and SSO for BW and the BI Launch Pad in the past year. Now I just need to put them all together.
I am using Analysis for Office (A4O) 1.4.2 and Business Object for Enterprise (BOE) 4.0 SP4 Patch11. I am using SAP BW for the backend.
I am starting a blank A4O workbook and I insert a data source via the BOE login using a (OLAP) connection on BOE to get to BW. I save the A4O to the BI Launch Pad. Now…when I open the BI Launch Pad and open the A4O from the BI Launch Pad…I get a sign on screen for BOE. How/what do I need to set up to not get that sign on screen for BOE (I am already signed on to the BI Launch Pad)?
On a side note…I do not have to sign on to BW. That is taken care of via a token between BOE and BW. And I have SSO set up so that when I go to the BI Launch Pad…I do not see the sign on screen. I am authenticated via Windows AD. And my OLAP connection to BW on the BOE system is set up with SSO authentication.
For the BOE sign on screen I have checked the “Enable Single Sign for Windows Active Directory” but I can’t get it to work unless I uncheck the box and put in my password (See below). The error I get when I check the box and leave the PW blank is below also.
Any help would be much appreciated.