TM1 Forum

Hi Guys,

I would like to initiate a chore to be kicked of via command line. We currently currently utilise RUNTI to do this for us but wanted to see if there
is an up to date equivalent but for executing chores via command line.

Cheers

Zark

I stand to be corrected but i don't believe there is.
We are stuck with utilising a "master" TI and calling that.
I also remember asking IBM/Cognos for the ability to run a chore from an action button years and years ago... now I tend to not really create chores for anything other than running 1 TI and then do all my calls in there; I think the chore functionality is extremely lacking and with a few small tweaks could be far more useful.

Hey Mate,

Thanks for the quick response. I was able to get a chore run from cmd line via here:
http://www.tm1forum.com/viewtopic.php?f=21&t=3486

Built my mike cowie

It works well, however i cannot encrypt the password in the batfile unlike RUNTI where you store the password in a .dat file
Apart from that it works fine. What was weird was that I could not see the thread processing when viewing TM1 top, however I knew that it was working since the chore was simple run TI processes that were dropping flat files into a directory.

Question is, will IBM be implementing something like this or will the developers have to cobble it together?

Cheers

Zark

7Zark7 wrote:Question is, will IBM be implementing something like this or will the developers have to cobble it together?

Asking questions like this in this forum is about as useful as making sure to close all the screen doors on a submarine. No one knows except the product development team at IBM and I'm pretty sure no one on that team has ever participated on this site. Every response you'll get is pure conjecture. I would say probably not since this has been a shortcoming of the tool for a long time. If they were going to provide a RunChore type thing they would have rolled it out when they rolled out RunTI, IMO. I would expect at some point you'll see task management rolled into the Cognos Configuration tool or something like it. That might be something that would demo well and sell more software which, in the end, is all they really care about. Making your job easier is way down the priority list.

Hi

I tend to avoid Chores, except for the obvious need to trigger something at a certain time, and for Startup Chores. I find the Chore interface too difficult to use as you have to go into each process to find out what the parameters are, and there is no easy way to copy a process down a chore with the similar parameters and then just alter one. There is no way to copy things from one chore to another.

Instead my standard routines include a Cube which allow a number of processes to be set up within a named master process, and each process can have parameters entered as cells in the cube. Comments can be entered. It also gives an indication as to which processes ran and which failed, and how long they took.

To trigger the master process, all I have to do is to call one Master Process Executing process which you could do via TM1RunTI and then pass in a single parameter of the name of the Master Process. The Master Process Executing process then references the Cube and executes each process in the cube. I find it more flexible than a Chore and more self-documenting.

Regards

Paul Simon

Hi Paul - I would be interested in the dimensionality of the standard cube (or cubes?) that you use for this and how it is maintained. I imagine the calling TI must do some kind of loop over the config cube to then do the sub-process calling (either via while loop on the prolog or construct a via and implicit loop of the data dab), and within the loop there must be a fair degree of testing for number of parameters of the sub-processes for how to call the ExecuteProcess? (or do you also completely do away with parameters and replace with CellGetS from another control cube?)

Hi lotsaram

Unfortunately this code took a lot of time to develop, and I can't just post it free of charge. However, you are along the right lines. The cube holds the process name and then up to 20 parameter name and value pairs. Just like a Chore there is going to be no one around to supply parameters when it runs.

Regards

Paul Simon