Programmatic control over Chore execution frequency

Suggest and discuss enhancements for TM1
Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Programmatic control over Chore execution frequency

Post by Steve Rowe »

Hi,
(Apologies for providing background on this again, two different enhancement requests arising from the same use case)

I'd like to be able to conditionally turn chores on and off and also manage the execution frequency from within a TI job. (actually I'd be happy to be able just turn them on and off but lets shoot for the whole piece!)

We are using PI to export and load data using 20 chores that are scheduled to run every 30 seconds. These chores only do work around 8 times a day when a master TI interacts with a schedule cube and sets various flags that indicate to the chores that there is work to do. This works v well and we are able to rapidly process data and minimise the read lock when loading data into the cube. We have not been able to note a performance down side to having the chores set-up like this.

There probably is one though, its just that TM1Top doesn't work in granular enough time for us to see the chores flicking on and off continuously.

As noted the high volume of logging this generates causes a problem (http://www.tm1forum.com/viewtopic.php?f=19&t=10156).

If we could turn the chores on in the master TI that signals that there is work to do this would solve a couple of problems.
1. Stop all the noise in the logs.
2. More importantly I think it would remove peoples nervousness around using chore driven PI TI execution and remove the need to go outside of TM1 to get to PI TI as they would have the fine control required.

Requests for programmatic access to chore settings have been bouncing around for a while now, especially from those who work across multiple time zones with daylight savings. Whilst this can be a big pain and lead to some dramatic issues if you don't remember to reschedule everything, I think that enabling easy access to PI really ought to raise the profile of this feature. PI TIs can be a real game changer but are currently challenging to implement.

Many places I have worked at, including my current employers, just won't consider introducing third party tools onto the hardware or giving developers access to the hardware. We have to use a chores.
Cheers,

Steve
Technical Director
www.infocat.co.uk
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Programmatic control over Chore execution frequency

Post by Alan Kirk »

Steve Rowe wrote: I'd like to be able to conditionally turn chores on and off and also manage the execution frequency from within a TI job. (actually I'd be happy to be able just turn them on and off but lets shoot for the whole piece!)
I've been meaning to raise this one for ages now and can only say a hearty "roger that". My issues with the absence of this functionality are:
- Chores can sometimes be turned on or off for a reason and it's all too easy to forget to toggle them back to their previous state. (The infuriatingly stupid change from icons which clearly mark out active chores in 9.5.x to the "subtle" ones that only someone who never has to use the software in anger could love in 10.1 doesn't help.) In the first instance you can get missed interfaces, in the second you can end up with log files the size of Mt. Olympus, and I'm referring to the Martian one here. Obvious and easy solution? The ability to run a periodic chore that ensures that all of the other chores are on or off (or rescheduled) according to the current date and/or time.
- This simple change would also get rid of the accursed daylight savings "bump" issue, since the master chore would simply manipulate the schedule time (in local time) each time it runs. That having been said, to make the feature set complete I think it would be advisable for the time setting to be done in either local or UTC to cover the needs of both people who work in one time zone and ones who work in several.

I can't see this being something that would take a huge amount of development effort but it would yield very substantial benefits for users.

Edit 18-Dec-14: Apparently I did bring this up two years before this port (closer to three at the time of making this edit). It's now been logged with the IBM RFE program (63585) where it will probably be ignored for another three years before being quietly removed from the list.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply