We have a night time job that updates our datawarehouse.
In Cognos 7, we had a script which checked when the datawarehouse load finished and then kicked off the Cognos reports and cube builds.
In Cognos 8.2 , is there a way to schedule reports so they run after the load? Some way to trigger the reports?
Terry
Yes, you want to investigate the use of Event Studio for this. ES will actually cache the results of queries and can determine from one run of the event to another if the data has changed.
Yeah, agree - EventStudio would be perfect for this task.
You could setup an ES Agent to 'poll' a table, watching for data conditions that say 'the datawarehouse update is complete'.
Then the Agent runs a report, emails it to the admins etc
You would just need to ensure that your update process ETL will create the 'polling' table data correctly.
Assuming you're using ReportNet, not Cognos 8 (based on the forum you posted in), Event Studio will not be available to you. If this is the case, read up in the documentation on the use of Triggers to launch jobs in ReportNet - you may need to resort to this mechanism instead.
Best regards,
MF.