Start TM1 process remotely without using the API

[ParisHilton]

I haven't managed to get the API to connect yet so I found this workaround, somebody might find it useful.

Basically you can use a TI process to detect the existence of a file. So what you can do is create a file from your external application when you want the TI process to start. You can then create a TI process that is scheduled to run say every 10 seconds. If it detects this file, then it kicks off your main process.

You also need to do a couple of housekeeping tasks to prevent repeatedly kicking off the process.
Namely, delete the run file once the TI process kicks and create an 'in progress' file so that the external app knows not to create a new 'run' file (unless of course that's what you want it to do).

The TI process can also write a completed file which the external process can use if need be.

You need to delete the files at appropriate stages depending on what kind of workflow you are after.

[lotsaram]

Although this approach will "work" an external trigger is definitely a better option and safer bet. Scheduling a process at this frequency has a high probability of causing locking and queuing of some degree as it is inevitable that at some point the process will overlap with another process / a data save, etc, etc.

[ParisHilton]

Although this approach will "work" an external trigger is definitely a better option and safer bet. Scheduling a process at this frequency has a high probability of causing locking and queuing of some degree as it is inevitable that at some point the process will overlap with another process / a data save, etc, etc.

Thanks lotsaram. I'll look into using the existing processexcute code already here, but at the moment I can't even connect to my server

[lotsaram]

Try this
http://forums.olapforums.com/viewtopic.php?f=3&t=11#p37

[ParisHilton]

I simply cannot get that to work (refuses to find my server)
However I used the new .net api with visual studio express 2010 to write a cheap and dirty app and success!!!!

Thanks for the pointers chaps.

(No pun intended...)