on 10-18-2019 6:00 AM
Hi
We have implemented a model that uses Master-Data on the fly extensively. Unfortunately we have hit a bug where refresh metadata results in an error. The workaround is to either log back off or to upgrade to EPM SP34 Patch 2+. The upgrade is a complex task and i am trying to find alternatives:
I have got the following working well in a non-Single Sign On development environment:
Sub RefreshMD() Dim oEPM As New FPMXLClient.EPMAddInAutomation
Dim oSheet As Worksheet
Dim strCon As String
On Error GoTo NoConnection
Set oSheet = ThisWorkbook.Sheets("Input")
strCon = oEPM.GetActiveConnection(oSheet)
On Error GoTo Oops
oEPM.RefreshConnectionMasterData strCon
oEPM.RefreshActiveSheet
Exit Sub
NoConnection:
MsgBox "You are not connected to BPC. Please login and try again"
Exit Sub
Oops:
oEPM.CloseConnection strCon
oEPM.Connect strCon "<<< how to use this without getting prompted for uname/password?
oEPM.RefreshActiveSheet
End Sub
Broadly if the .RefreshConnectionMasterData errors we branch to the Oops label, then we close and try to reconnect the connection. My question is in a SSO session, how can we connect or logon without being asked for a user name and password. Is this possible???
Thanks and best regards
Mike
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.