Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: Rita14 on 24 Jul 2014 03:20:14 PM

Title: How to create Event Studio event to run report after table update
Post by: Rita14 on 24 Jul 2014 03:20:14 PM
One of the db table (ADDRESS) will be updated once a week – on Monday
I need to create Event using Event Studio to check if table was update and then
right after table updated need to run report and send it to user.
Please let me know how I can accomplish this task using Cognos 10.2.1 Event Studio 

Thank you for you help.

Rita
Title: Re: How to create Event Studio event to run report after table update
Post by: JBCLARK20 on 28 Jul 2014 02:07:23 PM
Once you get the refresh date/time stamp for the table into a package,
you can compare the refresh date with the current date in your event.

refesh _date = current_date


Text only | Text with Images