Hello,
I've seen Canonical Date Henric Cronström and Linking to two or more dates from Rob Wunderlich. But I still confused.
This is the script for Canonical calendar:
DateLink:
LOAD
Case_ID, // Fact Key
[Receipt Date] as Date, // Fact Date
'Receipt' as DateType // Fact Type
RESIDENT CASE_TEMP; // from Case_Temp
LOAD
Case_ID,
[Aware Date] as Date,
'Aware' as DateType
RESIDENT CASE_REPORTS;
// Call Calendar Generator for field "Date"
CALL CalendarFromField('Date', 'CommonCalendar', '');
CALL CalendarFromField('Receipt Date', 'ICSRCalendar', 'ICSR '); // Create Calendar for OrderDate
CALL CalendarFromField('Regulatory Report Aware Date', 'ComplianceCalendar', 'Compliance '); // Create Calendar for ShipDate
This is the autogenerate date range script for Master calendar:
TempCalendar:
LOAD
Date($(vStartDate) + RecNo()) as TempDate autogenerate $(vEndDate) - $(vStartDate);
MasterCalendar:
Load
TempDate as Date
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
I also set up Variable Event Triggers and Field Event Triggers for Master Calendar.
What confused me are:
1. I am not sure if the set up is correct or am I missing anything? I guess I am not totally clear about the logic that how this works.
2. How can I use it for list box "Year, Quater, Month", Start date and End date Slider/Calendar Objects, as well as other chart or table objects? How should I set up these different date / date range objects based on my Master/Canonical calendar?
3. Shall I use Set Analysis: Sum( {$<DateType={'XXX'}>} Case_Count ) with all the objects listed above?
4. I am also using alternate state/assigned state to objects in different tabs. Do I still need to assign states to objects if I have Master/Canonical calendar? How can I achieve this goal?
Could anyone share with me any thoughts that help me think it though clearly?
Thanks a lot!
Becky
