How to force user to connect to TM1 using Excel macro?

[mce]

Hi,

When you open Excel, how do we force the user to log on to a TM1 server?
In server explorer, when you double click on a server name, then it prompts the user name and password.
I want to trigger this pop up box to appear when Excel opens or when users presses a button.
Any help would be appreciated.

Regards,

[lotsaram]

To invoke the Perspectives dialog I don't know of any other method other than using sendkeys (which I wouldn't recommend). Much better to roll your own dialog IMO.

[ajain86]

never tried this but....

how about creating a custom add-in that you would tell the users to add to excel with its only purpose to pop up the tm1 connect dialog box when excel open.

[MSidat]

Aye. The custom add in option works a treat.

Which also means you can handle incorrect passwords etc more effectively. We have it working here.

[mce]

In our security model, when double clicked in server name in server explorer, it does not open the standard TM1 user and password prompt, it opens a web page (of the authentication provider) and then you enter your user name and password in this page to authenticate to TM1 through Cognos 8. Therefore I cannot pick user and password in a custom pop up and pass this to TM1 as N_connect does not work with Cognos 8 security.