Schedule Chore to run based on dates in a 'table'

[melvinleng]

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

[Jeroen Eynikel]

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

[melvinleng]

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

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

[Jeroen Eynikel]

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

[Wim Gielis]

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

[melvinleng]

Hi Jeroen,

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

[Alan Kirk]

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.