Building cognos cubes once a batch has completed

[JGirl]

Hi,

At my organisation, we run a DataStage batch each night to update our data. Once this batch has finished running, I would like to be able to kick off a bat file to build several cognos cubes.

We are currently using cognos scheduler, but the limitation with this is that our batch finishes at different times each night, and noone wants to be awake at 3am checking the batch and kicking the file off manually.

I dont know too much about it, but apparently (way before I started) we were using some sort of VB functionality to do this (In case you cant tell, I know nothing about VB!), but that didnt work when we upgraded DataStage.

Also, we originally had some code in the batch itself to kick off the bat file, but there were problems with multiple windows being opened on the server.

Does anyone have any ideas on how I could (relatively easily!) automate the cube building bat file, to kick off as soon as the batch has completed? I would prefer any ideas that allow the DataStage batch to actually finish before the file is kicked off, rather that keep running while the bat file is executing, but any ideas will do at this stage.

Help Me Please!!!!!

Cheers
JGirl

 

[dpo]

hi,

you can create a job control that run your job (DSwait...), and after the successfull running you send a command line for building your cube.

rgds
Denis