Skip to Content
0
Oct 18, 2019 at 05:00 AM

BPC 10 SSO from VBA

116 Views

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