automated cube builds using TWS (Tivoli) scheduling

[tazman]

The company I am working has put down an edict that we need to build our Cognos cubes using the TWS scheduling software. Is anybody else using this? HOw did you go about using it if so.

[almeids]

I don't know that package but we use a 3rd party scheduler that runs on our data warehouse Unix box.  We used to build our cubes there too but now build on Windows.
In any case it's a matter of scripting the cube build using command line Transformer, in either a unix shell script or Windows .bat script.  If the scheduler and Transformer are on the same machine/platform it should be fairly straightforward to schedule the script execution in TWS; if crossing platforms, as we are now, you need to take one of 2 approaches: use some remote-run agent (probably need 3rd party software if crossing platforms) that lets you kick off a script on your Transformer platform from one on your TWS platform, or set up a watcher process to run on your Transformer platform all the time (or during relevant hours) and look for a trigger file sent from the TWS platform.
I can give you more details on our homegrown Unix-to-Windows interface if you're interested.
HTH