Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: fshahul on 16 Feb 2010 11:37:09 PM

Title: How to show all month names in report if there is no data for some months?
Post by: fshahul on 16 Feb 2010 11:37:09 PM
Hi,
I'm having Crosstab report.
Column: Period (Jan, Feb ...Dec)
Row: Fund Names
Measure: Revenue
We don't have data for some months ex: Jul, Sep, and Dec so in my report those months are not displayed (Months having data are displaying properly). Now my requirement is to see those month names in the report even if they don't have data.
I'm using Cognos 8.2 Version
Help me on this.

Thanks in advance.
Title: Re: How to show all month names in report if there is no data for some months?
Post by: paddhu on 17 Feb 2010 12:43:23 AM
Is your model dimensional? If yes, then you can drag the month members directly to the crosstab columns, rather than the month level.
Title: Re: How to show all month names in report if there is no data for some months?
Post by: DolAny on 17 Feb 2010 02:23:33 AM
fshahul,

Your time dimension is separate table - setup appropriate cardinality to let "time dimension" left outer join "your facts table".

Your time dimension is the same table where you store facts - no ways.
Title: Re: How to show all month names in report if there is no data for some months?
Post by: jive on 22 Feb 2010 10:49:42 AM
Hi fshahul,

I really prefer the second solution, this way if your month change in your report you will not have to reopen it each month and you will always see all the months.
Text only | Text with Images