Using existing report or query in EVENT Studio

[DaisySara]

Hello,
I am very new to Event Studio, with little training trying to figure it out myself.  How can I use a query or report I made in Query Studio or Report Studio in  Event Studio, to base an event off of that?  When in Event Studio, source tab only the package itself is available.  For instance, I want to look at the results of a report I created in Report STudio and run an event based on that.

[MFGF]

Hi,

Event studio agents are based on the results of an expression you code within the agent, and this needs to be something that evaluates to True or False. A simple example would be [Poster] = 'Muppet'  this would either evaluate to true or false (True in my case ;) Whatever logic you used in your report, you will need to replicate in your agent when you construct your expression.

Regards,

MF.

[DaisySara]

Thanks MFGF.  But then, how about if you have a complex report with more than one query?

[MFGF]

Hi,

Sounds a little like the situation RK was facing here. It's not an easy solution, but he got it to do what he needed.

http://www.cognoise.com/index.php/topic,20964.msg63385.html#msg63385

Regards,

MF.

[steve1961]

Hello,
I am very new to Event Studio, with little training trying to figure it out myself.  How can I use a query or report I made in Query Studio or Report Studio in  Event Studio, to base an event off of that?  When in Event Studio, source tab only the package itself is available.  For instance, I want to look at the results of a report I created in Report STudio and run an event based on that.

Once you have specified your condition you can ad a task that runs  report - you can then e mail that report to a user which is what we do in our envioment

[RKMI]

Thanks for the shout out MF!  ;D

Neways, yes... anything which is dependant on using complex logic such as adhoc prompt values or using union it can be done by using FM, creating a query subject with the SQL you intend to track you event on then publish the package to define your event. Which will acts like a trigger if you set it on schedule.

My scenario was to calculate current vs prior quarter values and find the change in Rev, Total Cost and if the profit for a specific LOB went up over 5%. It's sweet when things work but, ya took sometime to figure it out.

Thanks,
RK

[brandi]

Hi Folks

I have a user that wants to know if a report has any rows of data. If they do, then they want an email to them stating that there are rows

I don't see that you can create an agent based on a report, just a condition. Any ideas on this?

Thank you!

[MFGF]

Hi,

The report has a query which retrieves rows, so in theory you could code an expression in Event Studio to perform a count of the same data rows and see if it evaluates to >0?

Cheers!

MF.