Skip to Content
0

Using VBA to Bypass EPM Logon Upon Opening Excel

Feb 07, 2017 at 09:26 PM

797

avatar image

Greetings,

I've scoured the web for the answer to this question to no avail. I hope someone can help.

I use the EPM add in to pull data from BPC within excel. Is there a way to use VBA to automatically logon me into BPC? I currently have a SSO setup which allows me to bypass entering my credentials every time but I still have to click "Logon". I have tried creating macros but excel does not recognize when I click on the Logon button while recording the macro. Any assistance would be greatly appreciated. Thanks in advance!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Feb 07, 2017 at 10:46 PM
0

Please read EPM help API section. And get some training in VBA - macro recording is not the right way to automate EPM functions.

Show 7 Share
10 |10000 characters needed characters left characters exceeded

P.S. Help: 42.4.4.1 Connect

0

Hey Vadim....have you tested it? I am not able to get it to work....

0

Yes, it works without issues:

Dim epm As New FPMXLClient.EPMAddInAutomation
...
strConn = "_FPM_BPCNW10_[http://" & strServer & "]_[" & strEnvironment & _
            "]_[" & strModel & "]"
epm.Connect strConn, strUser, strPassword<br>

Assuming:

strServer - server URL like 10.0.10.31:8080/sap/bpc/

strEnvironment - environment name

strModel - model name

strUser - user name

strPassword - password

1

Thanks Vadim...But I was looking for the API version. Trying to execute it through EPMExecuteAPI......Connect. The connectionstring parameter is not working!

0

Sorry, but Connect function is not designed to be used with EPMExecuteAPI. Clearly stated in help!

0

My Bad! So I understood it wrong.....please correct me. so the API suggested in help from section 42.4.4.1 Connect and all others are to be used in macros and not in EPMExecuteAPI function????

0
Show more comments