How to display DataItem having no value in Crosstab ??

[slim]

Hi Cognoise friends,

Sceanario:
I have DataItem named Stores which have (StoreA, StoreB and Store C).
I need to create a crosstab which would display Stores in Crosstab Row, Year-month (eg. 2013-01, 2013-02, 2013-03...etc) in Crosstab Columns and in measure I need to display 'unique Customer Count'. Date range is for last 6 months.

Problem:
StoreA doesnt have any customer for last 6 months. So, Crosstab report doesnt display StoreA in Crosstab Row, but I need to display StoreA in Crosstab Row, and in it's corresponding measures display 0 or NULL or blank.

How can I achieve this in Cognos 8 ??

Many thanks,
Slim

[blom0344]

There must be tens of topics on this issue, so a little search will yield a lot of information.
To answer this in shorthand:
Option1:  Use the proper outer join strategy, either through the model or by using seperate locally joined queries.
Option2: Use a union set where the 2nd set brings in ALL possible combo's with dummy - zero - values