COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: shilpahv on 28 Jul 2007 06:55:12 AM

Title: Help required in automating cube build in Cognos 8 multiserver environment
Post by: shilpahv on 28 Jul 2007 06:55:12 AM
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.