rajmails2u
Programmer
How to automate the cube refresh using Scheduler?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cube Refresh
- Thread starter rajmails2u
- Start date
- Status
Hi,
To automate cube building with Cognos scheduler, you need to include your cube building commands in one or more Windows batch (.bat) files, and schedule these appropriately.
In your .bat file/s that you have scheduled you will need to include the commands to run Cognos Transformer in batch mode for each of the cubes you want refreshed. If you need advice on how to do this, let me know.
J
To automate cube building with Cognos scheduler, you need to include your cube building commands in one or more Windows batch (.bat) files, and schedule these appropriately.
In your .bat file/s that you have scheduled you will need to include the commands to run Cognos Transformer in batch mode for each of the cubes you want refreshed. If you need advice on how to do this, let me know.
J
You Could just run the command directly from your scheduler in the form
"Path to trnsfrmr.exe" -switch "Path to Model"
e.g.
"C:\Program Files\Cognos\cer1\bin\trnsfrmr.exe" -N -I -S "C:\Folder\MyModel.pyi"
You can find information about the switches by searching transformer help.
Good Luck Gary Parker
Systems Support Analyst
"Path to trnsfrmr.exe" -switch "Path to Model"
e.g.
"C:\Program Files\Cognos\cer1\bin\trnsfrmr.exe" -N -I -S "C:\Folder\MyModel.pyi"
You can find information about the switches by searching transformer help.
Good Luck Gary Parker
Systems Support Analyst
- Status
Similar threads
- Locked
- Question