Build/Update cubes

[Guest_imported]

Hi,
Does anyone has a script to build/update a cube. I am trying to write a batch script for Windows NT where a user goves a date and a time and a filename and the cube gets built at that time. I am very new to Cognos and have no idea about its features or limitations. Or is there any other elegant way to schedule this.

Thanks
Cognossier

 

[warque]

Hi,

I think u must first try to appreciate the purpose of having a GUI interface in Cognos. It should minimise the need to write any script in achieving whatever that you desire.

I believe your Cognos package should include the Scheduler which will serve your purpose of scheduling almost any task such as updating your cubes, generate reports (Which may take longer time in Impromptu) etc.

Try out the scheduler first and if you have any problem at all, feel free to comeback here and let us discuss it further.

rgds

 

[Guest_imported]

Our landscape requires that we use scripts. Moreover computers are supposed automate the manual jobs. You submit a script and let it do the work instead of you clicking on the buttons. A lot of resources could be saved by running scripts and automating as much as is possible. Just trying to be efficient if there is nothing wrong with it.

 

[warque]

Hi again,

I guess there is nothing wrong with using script at all, infact by using script you can actually some things which are perhaps too complicated to be supported by any GUI...

Sorry if I had offended you in any way....

rgds

 

[Guest_imported]

you simply need to write a .bat file which is then executed on a schedule as specified by the windows NT scheduler command.

Open a command prompt in NT. type AT /? for the syntax...

here is a sample of a batch file to build a cube. The transformer help file has more details on the command line options:

trnsfrmr.exe -n -i -k"Prod=User/Pass" "d:\Modelname.mdl"