If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Automate Creation of Cubes without using Scripts

Started by VRaj_90, 07 Jun 2013 12:10:04 PM

Previous topic - Next topic

VRaj_90

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..!!

Lynn


VRaj_90

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..

cognostechie

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. 

VRaj_90

Okay Cognostechie..!! Thanks for your reply..!! It helped me lot..!!  :)