COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: ramsfan on 29 Sep 2006 04:59:14 AM

Title: Cubeswap / cube rebuilds
Post by: ramsfan on 29 Sep 2006 04:59:14 AM
All ,

We are just getting started with the transformer and analysis studio (Cognos 8) products and are looking to automate many processes including data extracts and cube rebuilds.
We are aware of the cubeswap.bat process , but there does not appear to be any documentation with it or available from the Cognos Knowledgebase that makes much sense .
Has anyone got this working and can anyone assist with what should be in the various parameters.

The alternative of stopping the Cognos 8 service whilst rebuilds take place is not an option we can use.

Are there any other solutions - how is everyones else rebuilding/refreshing cubes automatically

thanks in advance
Title: Re: Cubeswap / cube rebuilds
Post by: Christenhusz on 05 Oct 2006 04:24:32 PM
hi,

unsecured cube:
  cubeswap.bat -dispatchername="http://<hostname>:9300" -datasource="great_outdoors_company" -url="http://<hostname>:9300/p2pd/servlet/dispatch" -windowscube="<drive>:\<path>\<cubename.mdc>"

secured cube:
  cubeswap.bat -dispatchername="http://<hostname>:9300" -datasource="great_outdoors_company" -url="http://<hostname>:9300/p2pd/servlet/dispatch" -username=<user> -password=<password> -namespaceid=<namespace> -unixcube="/<path>/<cubename.mdc>"

  Exit Codes:
             0 - Success
            -1 - Invalid command line arguments
            -2 - Login Failure
            -3 - Operation Failed

good luck

christenhusz