Page 1 of 1
How to force user to connect to TM1 using Excel macro?
Posted: Wed Mar 09, 2011 6:18 pm
by 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,
Re: How to force user to connect to TM1 using Excel macro?
Posted: Wed Mar 09, 2011 7:36 pm
by 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.
Re: How to force user to connect to TM1 using Excel macro?
Posted: Wed Mar 09, 2011 8:19 pm
by 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.
Re: How to force user to connect to TM1 using Excel macro?
Posted: Thu Mar 10, 2011 6:22 am
by 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.
Re: How to force user to connect to TM1 using Excel macro?
Posted: Thu Mar 10, 2011 9:22 am
by 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.