TI Process Function

[rfed]

Hey Everyone:

We have a Chore scheduled to run every night which runs several TI`s to update hierarchies from our corporate site. The first TI which runs is a TI to see if there have been any hierarchy changes. It looks for a trigger file which is generated from the corporate Essbase system, which is generated only if there are any updated hierrachies. If the Trigger file exists on the system, the chore process runs otherwise it quits the entire chore process.

We have had certain issues with this process where the trigger file reached a little late than the set time for the TM1 Chore process to run. Due to this we have been having so many issues on the Essbase side where the cubes do not get updated with the data in TM1.

Is there a TI function which could help me in running a loop to keep checking for the trigger file after every few minutes rather than quitting the chore.


Thanks in advance,

Rfed

[Michel Zijlema]

Hi Rfed,

The TI scheduler is quite limited in its scheduling options. You can only specify a frequency.

Things you could do are:
1. Create multiple chores, each scheduled at a different time. This has some maintenance pain and you need to make sure that a chore will not run the remaining processes if a preceding chore runs or has run for the given day.
2. You could schedule the chore to run every 5 minutes. If the file is not there the chore stops with ChoreQuit, if the file is there the chore will run the remaining processes, if the file already has been processed for the given day the chore stops with ChoreQuit. This will give processing overhead and you need to setup a semaphore (f.i. a control cube in which the chore logs whether the file was found and processed for the given day) to make sure the update is carried out only once.
3. You could use an external scheduler that offers a 'sleep/wake-up mode', that can start the chore execute executable to be found elsewhere on this forum.

Michel

[Wim Gielis]

Hello there,

If you say that "the trigger file reached a little late than the set time for the TM1 Chore process to run",
why don't you take a bigger timespan? Take say an hour between the moment the file should arrive, and the beginning time of the chore.

Maybe you tried that already, but I thought I would just mention it.

In any case, it will be a lot easier than the (nice) proposals of Michel.

Wim