Hello,
We need to broadcast a query every quarter. The catch is:
1. At the end of 1st quarter: ie Jan - Mar (2010) the query should run for the selection condition on dates: 01/01/2010 - 03/31/2010. And it should broadcast on the 1st working day in Apr, 2010.
2. At the end of 2nd quarter: ie Apr - Jun (2010) the query should run for the selection condition on dates: 01/01/2010 - 06/30/2010. And it should broadcast on the 1st working day in Jul, 2010.
3. At the end of 3rd quarter: ie Jul - Sep (2010) the query should run for the selection condition on dates: 01/01/2010 - 09/30/2010. And it should broadcast on the 1st working day in Oct, 2010.
4. At the end of 4rd quarter: ie Oct - Dec (2010) the query should run for the selection condition on dates: 01/01/2010 - 12/31/2010. And it should broadcast on the 1st working day in Jan, 2011.
Approach:
Do we need to create 4 copies of the same query? Then we can have the different selection conditions on each query and broadcast each of them at the end of the respective quarter. Even in this, my question is, how can I set this up for each year.
Any suggestions.
Regards.