How to display month in straight table even for columns that don't have data?

[#1]

Hi, I have a monthyear field in a straight table that displays the monthyear only when there is data in the other columns. How do I display the monthyear even though there is no data in the other columns? This is for completeness of the table to show all months. Thanks.

current:

monthyear	name	Site
01/2012	A	Z
02/2012	B	U
04/2012	C	L

I want it to be:

monthyear	name	Site
01/2012	A	Z
02/2012	B	U
03/2012	-	-
04/2012	C	L

[MK_QSL]

you need to create a monthyear field in master calendar....

Now after creating your above table, untick suppress when value is null in dimension table,,, also tick show all values

Under presentation tab, untick suppress zero values

[Anonymous]

Hi

check this

HTH

Regards,
Ravi N.

[vardhancse]

Hi,

Other than the date fields in the table, we can create one master calendar  based on the requirement.

In master calendar we can maintain fiscal as well as calendar.

So weather data is there or not, all the dates will display

[#5]

Hi, do you know why my first table (in bold and italics) for creating master calendar cannot be found? Thanks.

Temp: 

Load 

               min([Print Date]) as minDate, 

               max([Print Date]) as maxDate 

Resident A;

.

.

.  (the rest of the master calendar codes)

.

.

.

A:

LOAD

     .

     .

     .

     .

     .

     date(floor(timestamp#(Replace([PRINTDATE],' ',' '), 'DD.MM.YYYY hh:ss:mm'))) as [Print Date]   

FROM

<filename>

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[#6]

Hi, do you know why my first table (in bold and italics) for creating master calendar cannot be found? Thanks.

Temp:

Load

               min([Print Date]) as minDate,

               max([Print Date]) as maxDate

Resident A;

.

.

.  (the rest of the master calendar codes)

.

.

.

A:

LOAD

     .

     .

     .

     .

     .

     date(floor(timestamp#(Replace([PRINTDATE],' ',' '), 'DD.MM.YYYY hh:ss:mm'))) as [Print Date]  

FROM

<filename>

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);