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

[C8 Transformer?] Automate Cube Build

Started by jguevin, 20 Sep 2007 12:16:16 PM

Previous topic - Next topic

jguevin

not sure if this is the right thread for this, but does anyone out there know how to automate the cube build in transformer from SQL Server?  We have an ETL process that runs on SQL server and would like to somehow kick off the cube builds when the ETL process is complete.  Our DBAs currently have to log on to the server and manually kick off a batch file which then updates all the cubes.  Any help would be appreciated.
Thanks
Jeff

rocket

I'm assuming you're doing ETL with DTS, the built in SQL Server ETL tool?  If so, you can execute a command line / batch file from DTS directly.  When you created your DTS, you likely chained tasks to run in sequence, etc, right?  So at the very end, you can have it execute a batch file that kicks off the cube builds.

We have also created an e-mail notification at the end of our ETL so that the admins are notified when things are finished, etc.