Hello,
I have been struggling with creating a combined Master Calendar.
I now have the following problem:
There are two databases for our customers, one which contains two dates, the one at which the customer registered and the one at which he became active.
In the second database there are the transactions he has been doing over the time.
I am now trying to put this into one calendar so I can see -by filtering-, how many customers registered in a certain month, as well as how many transactions were processed.
I think the problem here is that there is only 1 date of registration resp. activation for a customer but there can be more than one date of transaction.
My code looks like this:
DateLink:
Load
fk_merchant_id,
month(DateReg) as Month,
year(DateReg) as Year,
'Reg' as DateType
Resident DB1;
Load
fk_merchant_id,
month(DateAct) as Month,
year(DateAct) as Year,
'Act' as DateType
Resident DB1;
Load
fk_merchant_id,
month(transactionDate) as Month,
year(transactionDate) as Year,
'TRX' as DateType
Resident DB2;
When I filter for a month it shows me the correct Registrations and activations but the TRx Data is accumulated until that very date.
Does it even make sense to create a master calender like this or should I create one for both databases.
Thanks a lot for helpful advise
Benjamin
