COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: anjidwh.cognos on 19 Nov 2013 05:16:06 AM

Title: Creating Event on SQL report
Post by: anjidwh.cognos on 19 Nov 2013 05:16:06 AM
Hi ,

I have a report say "Bank Acc Report'". This is generated on bais of SQL query. And the report contains the following fields.

1. Client Name-------------> Name of client
2. Bank Name-------------->Name of the bank
3.Changed Time----------->Date
4. Changed By------------->(Name)
5. Changed Type----------->(Update)
6. Is_Acc_Number---------->(Yes/No)

Now i have to create an event whenever the account number is changed to the client and send a email to the respective client or specific group.

Does Metadata required to create event condition and event key. If it is required, on which basis i have to check whether the acc number is changed or not.

Can anybody please help me to sort out this!!! Appreciate your help.

Thanks
RK