Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm going through the Exercise: Date Island in the Developer guide. I've made all the changes from TempDate to IslandDate on the MasterCalendar tab. but when I go into Dimensions I can't find IslandDate under AvailableFields/Groups. Can anyone advise what I might be missing?
Thanks.
Jon,
you don't have IslandDate.
You are loading it but renaming it to OrderDate.
'IslandDate AS OrderDate'
Marcus
Maybe a stupid question, but did you reload the document after changing the script?
Yes I did. I also went through the process for disassociating the MasterCalendar before that & reloaded it, but the the MasterCalendar is still linked to the rest of the data model. Could that be the where the fault is?
That sounds like you have to rename a field. Tables are linked on the fields they have in common. If you don't want a table linked to another table then they should not have fields with the same names.
I've already got IslandDate in the MasterCalendar, with the formula shown below:
MasterCalendar:
LOAD
IslandDate AS OrderDate,
Week(IslandDate) AS Week,
Year(IslandDate) AS Year,
Month(IslandDate) AS Month,
Day(IslandDate) AS Day,
WeekDay(IslandDate) AS WeekDay,
'Q' & ceil(month(IslandDate) / 3) AS Quarter,
Date(MonthStart(IslandDate), 'MMM-YYYY') AS MonthYear,
Week(IslandDate)&'_'&Year(IslandDate) AS WeekYear,
inyeartodate(IslandDate, $(vToday), 0) * -1 AS CurYTDFlag,
inyeartodate(IslandDate, $(vToday), -1) * -1 AS LastYTDFlag
RESIDENT TempCal
ORDER BY IslandDate ASC;
DROP TABLE TempCal;
Jon,
you don't have IslandDate.
You are loading it but renaming it to OrderDate.
'IslandDate AS OrderDate'
Marcus
Thanks.