Hi All,
Currently we have scheduled the cube build at a particular time. But we want the cube build to kick-off the moment ETL load finishes. So we have requested ETL team to create a Dummy text file in the Cognos Server once the ETL load completes, So how can I use the event studio further to check for the text file and start with the Cube build ?
You can use batch file to run cube. and schedule the job to call batch file after etl load is completed.
https://www.ironsidegroup.com/2012/06/05/automating-cube-build-in-ibm-cognos-transformer-10/
Assuming that the database is SQL Server (although this solution can be achieved with any given database platform). You can run the .bat\.cmd file through the sql script. Please ensure to place the batch file in the shared directory and must be accessible by the database engine. The T-SQL script which calls the batch script should be a part of the ETL jobs (perhaps the last step).