COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: strig1 on 25 Jul 2014 08:53:59 AM

Title: Simple Event Studio expression help needed
Post by: strig1 on 25 Jul 2014 08:53:59 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: huhumix on 25 Jul 2014 09:30:41 AM
HI,

I'll try an answer,,, I;m a newbie also :)

It seems like the calculation is problematic... you compare target start date + 4 to target start date, and will always be higher , of course ...

I think your calculation should be :  [Act Start Date] is null and current_date > [Target] ..

Hope it helps