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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help required in automating cube build in Cognos 8 multiserver environment

Started by shilpahv, 28 Jul 2007 06:55:12 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.