hi i am new in cognos. plz help me coz ihave a requirement : 1. to calculate rolling 3 months data from the reporting month.(Last Month). in which component i should create and save it?
first calculate current month number (1-12) from sysdate or whatever.
Then filter query like this:
[month column] >= [current month number] -3
and
[month column] <> [current month number]
If you don't have month column to compare, you need to extract that from your existing date column.
Use the Extract function add_months(Extract(?paramdate?,month),-3).