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