How to show all month names in report if there is no data for some months?

[fshahul]

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.

[paddhu]

Is your model dimensional? If yes, then you can drag the month members directly to the crosstab columns, rather than the month level.

[DolAny]

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.

[jive]

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.