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

 

cognos scheduler: how to dynamically schedule a report to run for previous month

Started by SAM2013, 19 Jun 2013 04:01:13 PM

Previous topic - Next topic

SAM2013

how to dynamically schedule a report to run for previous month?

what I have done:   
I have created 'Previous Month' as a Prompt in the report. From current_date function, I am calculating Previous Month value.
While scheduling the job,  i have selected 'Previous Month' as the promt value.

Issue:
When i run the report ondemand, the report is running for Previous Month (Showing May2013 Data).

But the scheduled report is showing April2013 data. Job is scheduled in May, so it is taking Previous Month of May, and showing April values.
The scheduler is not refresing the value of 'Previous Month' based on the calculation in the report.

How to dynamically schedule the report to run for Previous Month every day?

PS: 'Report View' of the report is scheduled, not the actual report. I have created 5 views of the report to run for previous 5 months. I am in Cognos 10.1


haverha

1) Don't work with the prompt!
2) Build a filter like Orderdate between dateadd(month,-1, Firstofmonth(getdate() ) ) and dateadd(month,-1, Lastofmonth(getdate() ) )
So now the report can run the whole month against pervious month data.