Hello! I was wondering if I could get some feeback. We currently download data from an ERP system on a nightly basis into our Cognos DW. Sometimes the refresh has issues that cause a delay in the data being avaliable to the users when they get to work. Most of the users have scheduled reports that run before they get to work though. I wanted to set some type of check in place so if the refresh is not done by X hour all schedules would be disabled. Then once the refresh is complete the schedules would be enabled again. Thank you in advance for any insight!
Hi,
There isn't really an easy way without using the SDK I would imagine to disable scheduled reports.
Perhaps you could handle it differently by setting up a job or series of jobs that are scheduled to run the reports and use the 'by trigger' to determine the frequency. Have your load process then call the cognos trigger.
Regards
Rob
Hi,
you could also set a table to get with one column and one line telling if the loading it's finish or complete normally. We used that technique here and it's work very well for us.
Regards Jacques