If you are unable to create a new account, please email support@bspsoftware.com

 

Help creating expression for comparing two time periods in event studio

Started by RKMI, 30 Jan 2013 10:52:46 AM

Previous topic - Next topic

RKMI

Hi,

We are currently using Cognos 10.2 trying to create an event studio agent against a relational model. To send an alert if there was an increase in Cost > 5% compared to current month vs. last quarter.

Thanks,
RK

RKMI

Solved it. :D

It might not be the best approach ;) but, it works.

Problem: Create an event for a relational model where you are comparing current month to last quarter for a specfied region and show % of change in cost.

Solution:
1. I made a report in report studio made query 1 for month and query 2 for last quarter.
2. Then I joined the two queries into one,
3. Copied the Cognos SQL modified to take a #prompt macro# for change of % change in cost and region.
4. Pluged the SQL in FM, publish package.
5. Created an event now at time of  event execution where I specify the values.

Thanks,
RK