cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Analyzer embedded into Microsoft Excel SSO

Former Member
0 Kudos

My customer is trying to configure the BEx Analyzer in Excel to not prompt for the logon. Does anyone have steps to configure the BEx Analyzer for SSO (Single Signon) NW2004s BI is used but they have many users that wan the Excel features.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184494
Active Contributor
0 Kudos

Thomas,

You could pass the logon credentials through macros if required... there was some discussion on this .. look up threads by Peter Knoer on VBA Scripting in Excel.. will also try and find out similar posts in the meanwhile... One of my colleagues had done something similar..

With Run("sapbex.xla!sapbexGetConnection") ' call the connection

' Set the params for Auto logon

.client = "100"

.user = STR_SAP_USERID

.Password = STR_SAP_PWD

'.Language = "YOUR LANGUAGE YOU LIKE TO USE FOR QUERY DISPLAY ( i.E. "EN")"

.SystemNumber = "<your system number>" '

.ApplicationServer = STR_SAP_PWD

.UseSAPLOgonIni = False 'important for automatic connection

.logon 0, True ' This will provide a dialog to appear

Arun

Hope it helps..