Print Page - report needs n monthes back sales

Title: report needs n monthes back sales
Post by: bala.km04 on 19 Jul 2010 11:57:41 AM

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

Title: Re: report needs n monthes back sales
Post by: Feanor on 19 Jul 2010 04:39:30 PM

I think the following thread could be helpfull.

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

Title: Re: report needs n monthes back sales
Post by: bala.km04 on 20 Jul 2010 04:17:00 AM

Quote from: Feanor on 19 Jul 2010 04:39:30 PM
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

Title: Re: report needs n monthes back sales
Post by: Feanor on 20 Jul 2010 05:00:50 AM

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

Title: Re: report needs n monthes back sales
Post by: Feanor on 20 Jul 2010 06:50:04 AM

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.)

Title: Re: report needs n monthes back sales
Post by: MFGF on 21 Jul 2010 06:08:50 AM

Quote from: Feanor on 20 Jul 2010 06:50:04 AMSince 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.

Title: Re: report needs n monthes back sales
Post by: blom0344 on 21 Jul 2010 06:19:11 AM

Quote from: bala.km04 on 19 Jul 2010 11:57:41 AM
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?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bala.km04 on 19 Jul 2010 11:57:41 AM