TM1 OptSet disable alerts?

[Andy Li]

Hi, i am currently doing a report automation and it requires me to prefix the admin host in order to get the right data from the server. I've come to know a TM1 macro function OPTSET. The macro works fine but however the prompt to disconnect from the all server keeps poping out. Does anyone know how can i prevent that popup from happening?

[Paul Segal]

Hi, i am currently doing a report automation and it requires me to prefix the admin host in order to get the right data from the server. I've come to know a TM1 macro function OPTSET. The macro works fine but however the prompt to disconnect from the all server keeps poping out. Does anyone know how can i prevent that popup from happening?

I realise this is a rather belated answer, but just for anyone who spends some time scratching their head over this - one answer is to put a sendkeys enter command in your code, but the trick is that it has to go before the optset command, like so:

Code: Select all

SendKeys "~", False
Application.Run ("OptSet"), "AdminHost", "NameofAdminHost"