COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: Cinu8 on 05 Apr 2012 09:35:47 PM

Title: Cube build via batch file
Post by: Cinu8 on 05 Apr 2012 09:35:47 PM
Hello

Cognos Gurus,

we are not able to build cube via batch files on windows 2008.
is any body have 2008 window and creating cubes via bat ?

please let me know.

thank you in advance

sree
Title: Re: Cube build via batch file
Post by: JaneSecrist on 09 Aug 2012 09:01:11 AM
We found the problem was when this was called from somewhere else - the security is not working - the problem is not the cogtr.exe - it is actually the server level security. 

What we did to resolve - We created an additional level command file that exeutes a windows scheduled task and the windows scheduled task calls the command to build the cube.

You have to have the security passed to cogtr.exe from the highest level task of the server.

Please feel free to contact me via email - ejsecrist@jlg.com and I can send you examples.