How to get latest 9 months data from cognos Report

[swarupa]

My Requirement is that when cognos report runs, it should pull always latest 9 months data depends on run time/date.
Can i get logic for this please ...

[cvamarley]

If I understand it correctly, Just adding the filter in your query like -

[date] between _add_months(current_date,-9) and current_date

should help !

[swarupa]

Thanks for your reply. And It should pull for last 9 months from previous business day...How to find out previous business day from current date logic....

[Mohanakrishnak]

you could use _day_of_week (current_date,1) function to find holiday.. I am sure that date dimension in your warehouse will have some indicators to find the Business working day or not..

[swarupa]

Yes i have indicator Prev_Buss_DT in one of the tables.
So need to pull data for last 9 months from previous business day.
Can you please provide exact logic ..