Master Calendar

[#1]

Hi

I have several QVDs with date fields (Year and Month). In other to avoid a loop, I have decided to use a master calendar but its still not working properly (the dates are not joinning) - e.g. when I select 2010, it does not affect the selection, it duplicates some of the data, etc. Could you please help me as its my first time using Master Calendar.

CalendarLinkage:

LOAD

  Year_O as [Calendar Year],

  Month_O as [Calendar Month]

From

data\SAPMM\Projects\BSID_OpenItems_Header.qvd (qvd);

CONCATENATE (CalendarLinkage)

LOAD

  Year_C  as [Calendar Year],

  Month_C as [Calendar Month]

FROM

data\SAPMM\Projects\BSAD_ClosedItems_Header.qvd (qvd);

CONCATENATE (CalendarLinkage)

LOAD

Year as [Calendar Year]

from

\\10.193.2.14\qvapps\Live\InlinePurchases_2.xls

(biff, embedded labels, table is Sheet1$);

Thanks in advance

[#2]

Thanks for the sync table help.

Do i need to include the primary key for each qvd?

let vStartDate= num(MakeDate(2010));

cal1:

load Date($(vStartDate)+RowNo()-1) as Date

AutoGenerate(num(today())- $(vStartDate)+1);

cal2:

load

*,

year(Date) as ,

Month(Date) as Calendar Month],

Day(Date) as Day,

dual((Month(Date) &'-'&Year(Date)),num(MakeDate(year(Date),month(Date)))) as Monthyear

Resident cal1;

drop table cal1;

CalendarLinkage_Sales:

LOAD

%InvoiceBillingDocument_Key,

Year_O as ,

Month_O as

From

data\SAPMM\Projects\BSID_OpenItems_Header.qvd (qvd);

CONCATENATE (CalendarLinkage_Sales)

LOAD

%InvoiceBillingDocument_Key,

Year_C as ,

Month_C as

FROM

data\SAPMM\Projects\BSAD_ClosedItems_Header.qvd (qvd);