COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: tazman on 20 Feb 2008 12:39:28 PM

Title: automated cube builds using TWS (Tivoli) scheduling
Post by: tazman on 20 Feb 2008 12:39:28 PM
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.
Title: Re: automated cube builds using TWS (Tivoli) scheduling
Post by: almeids on 12 Mar 2008 11:44:11 AM
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