Hello Cognos Gurus,
My Project has requirement that I want to automate the process of creation of cube so that it will reflect the updated query data in the metric package in which I am using it. I found some techniques but the were using the scripts. I want to automate it without using the scripts, any suggestions are needed asap..
Thanks in advance..!!
Why not use scripts?
Actually Rest of the process I've made without using scripts and I found somewhere that it can be done by using some options in Transformer, I am using cognos Tranasformer v10..
What you 'found somewhere' means that there are some deployment settings that has to be done in Transformer but there will be a script that will 'invoke' Transformer to start the process that builds the cube. Those settings in Transformer are for versioining of the cube and to make the latest version active for the reports to use.
Even before the versioning feature was introduced, the cube was always built by Transformer and the scripts were there merely to invoke Tranformer to start the build process. Rest of the things in the script of earlier versions were for copying/moving the cube etc.
In other words, the Cube was never built by the scripts. The scripts were there only to invoke Tranformer and it was always Transformer that was building the cube. The script and Transformer are not alternates to each other but the script rather compliments Transfomer for an automated process. Hope this clears your confusion.
Okay Cognostechie..!! Thanks for your reply..!! It helped me lot..!! :)