report needs n monthes back sales

[bala.km04]

hi every body i am new to cognos.i have one query.report contains 2 prompts.one for year(2010,2011 etc),another for month(jan,feb etc).if i select feb 2010 then report need to show 5 monthes back sales.Here notice that report needs to retrieves  3 monthes of previous year also.thanks in advance

[Feanor]

I think the following thread could be helpfull.

www.cognoise.com/community/index.php/topic,10287.0.html

[bala.km04]

I think the following thread could be helpfull.

www.cognoise.com/community/index.php/topic,10287.0.html

hi  feanor i gone through that link.but i didnot understand.because i am very beginer.so plz post logic to solve my query.thanks in advance

[Feanor]

Are you building a report on a dimensional or relational model?

[Feanor]

I've created a report on a relational Framework-model that meets your requirements. Use the following link to download and import it in report studio. Since I can not upload files to the forum I placed the file on rapidshare.

http://rapidshare.com/files/407969565/report.txt

Let me know if this any help.
(I also appreciate if people like to share other kind of solutions.)

[MFGF]

Since I can not upload files to the forum I placed the file on rapidshare.

For an XML report spec, you could simply copy and paste it into a message on the forum, if it's easier.

Just a thought...

MF.

[blom0344]

hi every body i am new to cognos.i have one query.report contains 2 prompts.one for year(2010,2011 etc),another for month(jan,feb etc).if i select feb 2010 then report need to show 5 monthes back sales.Here notice that report needs to retrieves  3 monthes of previous year also.thanks in advance

It may be a bit easier to define a single calender prompt and base your logic on the date selected. This way you can use the whole bunch of standard date/time functions available.

Your logic seems a bit questionable though. Suppose sep2010 would be selected.
Do you mean that you want to select  the range of   april2010 - august2010  as well as  oct2009-dec2009?