If you are unable to create a new account, please email support@bspsoftware.com

 

Help required in automating the Cognos 8 cube build process using a batch file.

Started by shilpahv, 28 Jul 2007 06:52:53 AM

Previous topic - Next topic

shilpahv

Hi All,

The automation of cube builds in a Cognos 8 Multiserver environment is failing in the follwing scenario:
Multiple CUBESWAP commands are not working from a single bat file.  The file gets aborted after the first instance of CUBESWAP in it.
Hence no statement after that gets executed and our automation process fails.

There is one suggested solution which is not a very great design -
Have multiple bat files, one for each cube swap and have a parent bat file which calls the other files in the appropriate sequence.
But this is not a great design if we have 4 to 5 production servers - we will need 4 files for forward cube swap and 4 files for reverse cube swap. 

So please suggest any other optimal solutions.

Thanks in advance.