1

We are running SAP BW with BExAnalyzer 7.5. I've been trying for days to establish a connection to the SAP BW server, but unfortunately I am not even receiving an error message. So it seems the logon has succeeded, but no data from BW is fetched, so I am assuming there is a problem in the logon. Please help!

Function LogonToServer() As Boolean
   LogonToServer = False
   Dim myConnection As Object
   Set myConnection = Run("'C:\Program Files (x86)\Common Files\SAP Shared\BW\BExAnalyzer.xla'!SAPBEXgetConnection")
   With myConnection
      .client = "xxx"
      .user = "xxx"
      .Password = "xxxx"
      .Language = "DE"
      .systemnumber = "xxx"
      .system = "xxx"
      .ApplicationServer = "xxx"
      .SAProuter = ""
      .Logon 0, True
   End With
   If myConnection.IsConnected <> 1 Then
      'launch the Logon Dialog for manual connection
      myConnection.Logon 0, False
         If myConnection.IsConnected <> 1 Then
            MsgBox "something went wrong ..."
            Exit Function
         End If
   End If
   If myConnection.IsConnected = 1 Then
      LogonToServer = True
   End If
   Run "BExAnalyzer.xla!SAPBEXinitConnection"
End Function
Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
RWatermelon
  • 63
  • 1
  • 1
  • 11

1 Answers1

1

SAP Note 2541995 says that the cause is that the Password property is not available in 7.5. It suggests that you can reconnect if you are using Single Sign On (SSO). It also points to note 2635165 that is a front end patch that may fix the issue with the password property. The code you attached does work with version 7.4 and I experienced similar issues with 7.5 but do not have access to download the patch. I'll try and get the front end patch and test again and update my answer with the results.

mperry
  • 91
  • 5
  • We managed to solve this issue. It seems that {code} Run "BExAnalyzer.xla!SAPBEXRefresh" {code} did the trick. There was no need to activate Single Sign On. – RWatermelon Jul 30 '18 at 08:37
  • I have same issue. Showing SAP dialog box and need to provide password. How did you solve this issue? Thanks. – Thit Lwin Oo Jan 23 '19 at 01:49