[SOLVED] Cubeswap help required

[ramsfan]

All ,

We are just getting started with the transformer and analysis studio 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

[MFGF]

Hi,

The easiest way to see the arguments required is to get to a command window, navigate to the cubeswap folder, and run cubeswap.bat with no arguments specified.  This should then list all the required and optional arguments with descriptions of what they are.

Hope that helps!

MF.

[cognosjon]

We ran the cubeswap.bat file as suggested( thanks for that can't believe we didn't think of that to start with!!!)

we have detailed the bat file and have tried to run it from a command line. It executes with no error messages but the conection string we are trying to change has not been altered.

Any thoughts.

I have copied the contents of our cubeswap.bat file below.

@echo off

remÃ,  Copyright 2005 Cognos Incorporated. All Rights Reserved.
remÃ,  Cognos and the Cognos logo are trademarks of Cognos Incorporated.

rem Relative definitions based on Cognos 8 installation location.

set JAVA_HOME=../../../bin/jre/1.4.2/
set CRN_HOME=../../../

set JAR_HOME=%CRN_HOME%webapps/p2pd/WEB-INF/lib

set CLASSPATH=.
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/axis.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/axisCrnpClient.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/commons-discovery.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/commons-logging.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/jaxrpc.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/saaj.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/xml-apis.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/xercesImpl.jar


"%JAVA_HOME%bin/java.exe" -classpath %CLASSPATH% CubeSwap "http://GCK23S007:9300/p2pd/servlet/dispatch" "http://gck23s007:9300" "Sales Cube Data" "c:\program files\cognos\c8\powerplay cubes\VersionA\sales.mdc" <username> <password>

[cognosjon]

Problem solved, we forgot to include the namespace at the end. so it had no idea of where our authentication was coming from.

Our cubeswap.bat file in full working order now appears as follows

@echo off

rem  Copyright 2005 Cognos Incorporated. All Rights Reserved.
rem  Cognos and the Cognos logo are trademarks of Cognos Incorporated.

rem Relative definitions based on Cognos 8 installation location.

set JAVA_HOME=../../../bin/jre/1.4.2/
set CRN_HOME=../../../

set JAR_HOME=%CRN_HOME%webapps/p2pd/WEB-INF/lib

set CLASSPATH=.
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/axis.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/axisCrnpClient.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/commons-discovery.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/commons-logging.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/jaxrpc.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/saaj.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/xml-apis.jar
set CLASSPATH=%CLASSPATH%;%JAR_HOME%/xercesImpl.jar


"%JAVA_HOME%bin/java.exe" -classpath %CLASSPATH% CubeSwap "http://GCK23S007:9300/p2pd/servlet/dispatch" "http://gck23s007:9300" "Sales Cube Data" "c:\program files\cognos\c8\powerplay cubes\VersionA\sales.mdc" "Username" "Password" "NAMESPACE"

[sjallipalli]

Thanks, this actually helped me.
Sree