COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: yeluri9 on 15 Sep 2015 03:15:47 PM

Title: Schedule report by quarter
Post by: yeluri9 on 15 Sep 2015 03:15:47 PM
Hello

I need help , How can we schedule Job by Every quarter 1st Monday . 


please provide some hints how to do it.

Title: Re: Schedule report by quarter
Post by: Francis aka khayman on 16 Sep 2015 01:33:50 AM
Frequency:
Select the frequency by clicking on a link.

By Month

The First Monday of every 3 month(s)

Title: Re: Schedule report by quarter
Post by: yeluri9 on 17 Sep 2015 12:50:10 PM
thanks...
Title: Re: Schedule report by quarter
Post by: yeluri9 on 17 Sep 2015 01:20:35 PM
But , we need to run  1 st working business day of 3 months.

As per your suggestion  it run on 1 off 3 months....

some time it will be Sunday or Saturday report should not run...


Please help me....
Title: Re: Schedule report by quarter
Post by: Francis aka khayman on 17 Sep 2015 08:49:58 PM
you said first monday. now first working business day. you in the middle east or something?

give clear requirement, gosh you are like my users  >:( >:( >:(

:P :P :P :P :P peace  ;)

Quote from: khayman on 16 Sep 2015 01:33:50 AM
The First Monday of every 3 month(s)

Quote from: yeluri9 on 15 Sep 2015 03:15:47 PM
I need help , How can we schedule Job by Every quarter 1st Monday
Title: Re: Schedule report by quarter
Post by: yeluri9 on 18 Sep 2015 12:24:31 AM
Sorry, Today my user changed requirement... so please let me know how can we do...
Title: Re: Schedule report by quarter
Post by: Francis aka khayman on 18 Sep 2015 01:22:07 AM
users...

you might need something like event studio and a calendar of holidays to pull that one off.

or for crude solution, create 5 views and run one every first monday, another every first tuesday, etc.

use the output for whatever the first working day for that quarter