Hi All,
Can anyone explain how can we implement the trigeer based exceution of TI process.
If there is any documnet or use case plz share it.
Any help would be very useful.
Thanks,
Abhishek
Trigeer Based Exceution of TI
-
aagrawal12
- Posts: 21
- Joined: Thu Nov 05, 2009 8:56 am
- OLAP Product: TM1
- Version: 9.4.1 9.5.1 9.5.2 and 10.2.2
- Excel Version: 2003 2007 and 2010
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Trigeer Based Exceution of TI
TM1 has no built in trigger functionality. Having said that, you could write a TI which runs as a chore at specified intervals, tests some aspect of your model and takes appropriate action.
-
kpk
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Trigeer Based Exceution of TI
Or you can create an exe which can be triggered from outside TM1.David Usherwood wrote:TM1 has no built in trigger functionality. Having said that, you could write a TI which runs as a chore at specified intervals, tests some aspect of your model and takes appropriate action.
I have one which let you start a predefined chore.
Best Regards,
Peter
Peter
-
wissew
- Posts: 54
- Joined: Tue Jun 17, 2008 7:24 pm
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2; 11
- Excel Version: 2003 SP3 - 2013
- Location: Beaverton, OR
Re: Trigeer Based Exceution of TI
There are a couple of ways to go about this and it depends on the type of trigger you are looking to execute.
Since TM1 chores will only execute daily you start the prolog with an if statement:
if(condition or file exists);
ChoreQuit;
endif;
Then utilize windows scheduled tasks to execute a dos file that copies the file to the desired location weekly and delete the file on the epilog tab at the end of your chore. You can also utilized a TM1 string or numeric cube to store the conditions for executing the chore. TI can also execute the dos file that triggers other chores to run or not to run.
Since TM1 chores will only execute daily you start the prolog with an if statement:
if(condition or file exists);
ChoreQuit;
endif;
Then utilize windows scheduled tasks to execute a dos file that copies the file to the desired location weekly and delete the file on the epilog tab at the end of your chore. You can also utilized a TM1 string or numeric cube to store the conditions for executing the chore. TI can also execute the dos file that triggers other chores to run or not to run.