Logging to Analysis for Office with different (no SSO) user

Single Sign On authentication scheme is very popular and useful for users. While user is successfully authorized by OS with the same login ID is allowed to access to other applications. In many organizations, it is deployed also for SAP systems. In one of my previous posts, I described how to avoid SSO for Analysis for Office. However, in case user has no possibility to edit entries to SAP systems in SAP Logon Pad – simply just deactivating the SSO for particular SAP system will not help.

Luckily, there is another option. First following settings of the AfO need to be adjusted. In Options part of Analysis Customizing available menu on MS Excel: File -> Analysis -> Customize Analysis -> Options:

Switch to Advanced tab and choose and enable following two check boxes:

-      Allow Client and language Selection for SSO Logon

-      Force Logon Window for SSO Logon on BIP

Now try to open Insert Data Source -> Select Data Source for Analysis a BW report while selecting menu on Analysis ribbon, and Skip below popup window:

On next pop-up, choose particular BW SAP system, which you want to log on into:

Choose Cancel for next pop-up:

Finally, you are prompted to enter logon criteria for non-SSO user:

More information:

Bypassing SSO in Analysis Office (AO)

Logging to SAP BPC Add-in with different (no SSO) user