Schedule of Transformer Cube for MS SQL Server Agent

[phanicrn]

Hi

I have transformer cube, i want to schedule from ms sql server agent, what is the procedure i can schedule the cube from sql server agent, do we have to write any macro for cube execution.
Thanks
phani

[MFGF]

Hi,

In Transformer, launch the Help application, go to the Contents tab, and open up the documentation on Command-line options.  This will show you all you need to know to run Transformer from the command line, and you should be able to build up a command to refresh your cube(s) which you can then call from your favourite scheduling tool.

The other option is to code yourself a CognosScript macro to launch Transformer, open the model, build the cube, then close the model and Transformer, save then schedule the macro, but this relies on some knowledge of the appropriate syntax, objects and methods to use in the CognosScript Editor.

Regards,

MF.

[phanicrn]

i didnt find any specific command line for calling transformer cube and scheduling it from sqlserver agent

I really appreciate if some one give me the step how to call the transformer cube..

Thanks
phani