我们正在使用BExAnalyzer 7.5运行SAP BW。我已经尝试了几天来建立到SAP BW服务器的连接,但不幸的是,我甚至没有收到错误消息。看起来登录成功了,但是没有从BW中获取数据,所以我假设登录中有问题。救命啊!
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
1条答案
按热度按时间olmpazwi1#
SAP Note 2541995指出原因是Password属性在7.5中不可用。它建议您在使用单点登录(SSO)时可以重新连接。它还指向注解2635165,这是一个前端修补程序,可以修复密码属性的问题。您附加的代码可以在7.4版本中使用,我在7.5版本中遇到了类似的问题,但无法下载补丁。我将尝试获得前端补丁并再次测试,并将结果更新为我的答案。