Same as in Qlikview, so perhaps this blogs explains what you need to know: The Master Calendar
These discussions may be of interest too:
I read the blog about the master calendar, but I still don't quite understand how to use it.
I've tried to write the following in my data load:
Year(SupplierInvoiceDueDate) as Year,
Month(SupplierInvoiceDueDate) as Month
The problem is that I have another date which I also want to be considered in the calendar - InvoiceDueDate.
But when I enter the above script with InvoiceDueDate as well I get a synthetic key error.
How can I fix this?