COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: raviahuja21 on 14 Feb 2014 06:50:07 AM

Title: Automating Deployment of Powerplay cube
Post by: raviahuja21 on 14 Feb 2014 06:50:07 AM
Hi Folks

I am using Cognos BI 10.2.1 FP 1 on  windows server 8 machine.

I have created a couple of transformer cube and would like to automate them by adding some scheduling process using command line syntax.

I have written the following syntax. I have also entered the datasource sign on credentials.

What happens is that it runs the .bat file without any errors and the screen shows the transformer version and disappears without any cube getting build.


cd C:\Program Files (x86)\ibm\cognos\c10\bin
cogtr.exe -n2 -g"Clinical Status Netezza" -m"D:\Temp\ClinicalStatusNetezza.mdl"



Can anyone help me with this?
Title: Re: Automating Deployment of Powerplay cube
Post by: Grim on 14 Feb 2014 08:45:46 AM
What does the cube build log say? Can you post it here?
Title: Re: Automating Deployment of Powerplay cube
Post by: sdf on 16 Feb 2014 06:28:37 PM
can you try to input "pause" in your .bat just to check if it reflects any error.

Or you can try to complete your syntax specifying the logdirectories.

Here is a sample of what i am using.


"C:\Program Files (x86)\ibm\cognos\c10\bin\cogtr.exe" -nologo -n2 -r4 -dLogFileDirectory="D:\Cube Automation\Logs" -dMultiFileCubeThreshold=7500000 -dEnablePCOptimizer=1 -dDataSourceDirectory="D:\Cube Automation\Model" -dCubeSaveDirectory="D:\CUBE" -dDataWorkDirectory="D:\Cube Automation\DEV" -dModelWorkDirectory="D:\Cube Automation\DEV" -dModelSaveDirectory="D:\Cube Automation\Model" "D:\Cube Automation\Model\Sample.pyj"

I can see in your syntax that it is similar to the syntax used in linux cube building