Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: RKMI on 30 Jan 2013 10:52:46 AM

Title: Help creating expression for comparing two time periods in event studio
Post by: RKMI on 30 Jan 2013 10:52:46 AM
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
Title: Re: Help creating expression for comparing two time periods in event studio
Post by: RKMI on 31 Jan 2013 06:32:31 PM
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
Text only | Text with Images