COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Dynamic Cubes => Topic started by: Esperanza on 26 Dec 2012 12:43:55 PM

Title: Launch Dynamic Cube From SQL Server SSIS
Post by: Esperanza on 26 Dec 2012 12:43:55 PM
Hello Cognos Experts !,
Is there a way to launch a Dynamic Cube from SSIS?
Our data is refresh with SSIS every 4 hours.
It would be nice if we could start the update of the Dynamic Cube from SSIS as well.
Thank you in advance.
Esperanza
Title: Re: Launch Dynamic Cube From SQL Server SSIS
Post by: Rahul Ganguli on 31 Dec 2012 02:05:08 AM
There should be a way to refresh Dynamic Cubs from command line. You can call this command line utility from SSIS package as file system task.