How to write a macro to update a transformer model?

[Guest_imported]

I am trying to write a macro to update my transformer model and rebuild the cube.

 

[griffindm]

Here's one approach from the Cognos Knowledgebase:

Description

Can a BAT file that includes a command to build a cube be called from a macro?

Solution:

Yes you can execute any BAT file from a macro using the shell function.

If for example the Bat file (using build.bat) contained a command to build the cube in batch mode:

"x:\Program Files\Cognos\cer1\bin\trnsfrmr.exe" -n -s "E:\Great Outdoors Company.mdl"

Then the macro can call the BAT file through the shell function:

Sub main()
shell("e:\build.bat&quot
end sub

HTH,

Dave Griffin 'Happy July 4th!'

 

[Jbond007]

Thank You for the Suggestion
I am trying to write a macro to update the model and rebuild the cube. so that i can run the macro using scheduler at regular intervals.

It will be great if you can try to help me in this aspect.