COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Event Studio => Topic started by: strig1 on 25 Jul 2014 08:52:14 AM

Title: Simple Event Studio expression help needed
Post by: strig1 on 25 Jul 2014 08:52:14 AM
I'm new to event studio and i'm trying to run a basic event trigger. I am using a primavera package and my trigger is "Email __bob___ when a task is not started within 4 days of scheduled start date.

Expression as of now: [Act Start Date] is null and [Target + 4] > [Target Start Date]
-where [target + 4] is a calculation: [Target Start Date ]+ 4

I need advice as to why this isn't working, am i missing a component? I feel like the calculation is what is the problem. The picture provides the actual information that the query has. Thanks!

(http://i.imgur.com/IzjjPR5.png)
Title: Re: Simple Event Studio expression help needed
Post by: Raghuvir on 06 Aug 2014 10:42:50 AM
Quote from: strig1 on 25 Jul 2014 08:52:14 AM
I'm new to event studio and i'm trying to run a basic event trigger. I am using a primavera package and my trigger is "Email __bob___ when a task is not started within 4 days of scheduled start date.

Expression as of now: [Act Start Date] is null and [Target + 4] > [Target Start Date]
-where [target + 4] is a calculation: [Target Start Date ]+ 4

I need advice as to why this isn't working, am i missing a component? I feel like the calculation is what is the problem. The picture provides the actual information that the query has. Thanks!

(http://i.imgur.com/IzjjPR5.png)

hi Strig,

Have you scheduled your event to run daily ?

Regards
Title: Simple Event Studio expression help needed
Post by: MFGF on 07 Aug 2014 02:46:19 AM
Quote from: strig1 on 25 Jul 2014 08:52:14 AM
I'm new to event studio and i'm trying to run a basic event trigger. I am using a primavera package and my trigger is "Email __bob___ when a task is not started within 4 days of scheduled start date.

Expression as of now: [Act Start Date] is null and [Target + 4] > [Target Start Date]
-where [target + 4] is a calculation: [Target Start Date ]+ 4

I need advice as to why this isn't working, am i missing a component? I feel like the calculation is what is the problem. The picture provides the actual information that the query has. Thanks!

(http://i.imgur.com/IzjjPR5.png)

I think your issue is with the calculation - trying to add an integer (4) to a date. Try using the _add_days() function to add four days to your date.

Cheers!

MF.


Sent from my iPad using Tapatalk HD