COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: davidcognos on 29 Oct 2010 05:13:28 AM

Title: Schedule a Half - yearly Report
Post by: davidcognos on 29 Oct 2010 05:13:28 AM
Hi,

The scheduling of the report is Half - yearly. The report to be generated in end June and end December. Therefore the December report to show statistics for January to June of Current Year and June report to show the output of last year July to December. Based on batch run date the data gets populated into the database tables. The logic is handled in the report but how should i set the scheduling.

In the Scheduling page, how should i set the properties. Do I have to select the option 'By Month' and select 30th day of every 6 months or do I have to set the Start date and End Date.  Currently it is october month but how should I do the setting to deliver the report.

Thanks in Advance!!

Regards





Title: Re: Schedule a Half - yearly Report
Post by: josepherwin on 25 Nov 2010 09:52:04 PM
Have you tried looking at Trigger based scheduling?

The scheduling in Cognos is not very flexible to handle complex requirement.

Use your Task scheduler (windows) or Crontab (UNIX) to create a trigger file on your desired date frequency.