Essbase Add-In: Problem connecting to server

Hi All,

I am having an issue connecting to a server using the Excel Add-in Essbase. The report in question includes a macro button on the control page that, when actioned, prompts an Essbase login and then retrieves from a particular cube. When I enter my username and password then click OK to run, the Essbase login box loops back (pops back up again) and does not retrieve. Below is the VBA code I use to connect to Essbase, which I use in every other report daily, and it works/retrieves with all of them except this report. Has anyone had this problem? Please help, I've scoured forums with no luck!

Please Login or Register  to view this content.

*Also, keep in mind that this only happens on my workstation. Macro runs fine on my coworkers computer.

Any advice would be appreciated! Thanks so much