TM1 Forum

Hi all,

How do I run a Chore (TI processes) every period, following the company's accounting calendar?
I might have a 'table' (in the form of a dimension or cube), which stores the dates which we want the chore to run.

For example, i have a table (dimension, cube, etc) with the schedule:
02-01-2011
04-02-2011
03-03-2011
01-04-2011
...

And i want to run the Chore on these dates.

Thanks.

Regards,
Melvin

Assuming you are only going to use core TM1 functionality.


* create a lookup table as follows:

dim1: date dimension, containing all dates
dim2: list of chores
put f.i. a 1 in every cell of this cube where the chore needs to run

* set the chore to run every day

in the prolog section do a lookup and see whether the setting in your lookupcube for the system date and that chore is a 1 or zero.
If it is not 1 => Chorequit

Hi Jeroen,
Thanks for your advice. I think i get what you mean.

Any one else got other ways of doing this?
Thanks!

Another way of doing it would be to use the windows scheduler and call the chore with a .bat file.

Hello Melvin,

If it is only 1 chore that you run, I would create a dimension with only the dates it has to run (and check the format of the date to make the TI coding easy).
A simple DIMIX will then suffice.

A .bat file (as Jeroen mentioned earlier) could contain the TM1runTI call. If would just stick with a simple TI process that is scheduled every day. Including an IF test on the day, and that's it.

Wim

Hi Jeroen,

Can a windows batch file call a TM1 Chore?
How do I do that?
Just want to consider all options.
Thanks.

melvinleng wrote:Hi Jeroen,

Can a windows batch file call a TM1 Chore?
How do I do that?
Just want to consider all options.
Thanks.

IBM has kinda-sorta released an .exe which can be run to execute a chore on a TM1 server. See this thread for further details.