If you are unable to create a new account, please email support@bspsoftware.com

 

Triggering reports to run after a datawarehouse update

Started by terry_stjean, 13 Sep 2007 01:12:13 PM

Previous topic - Next topic

terry_stjean

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

MDXpressor

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.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

mikewalker

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.

MFGF

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.
Meep!