IslandDate not available in AvailableFields/Groups

[#1]

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.

[Gysbert_Wassenaar]

Maybe a stupid question, but did you reload the document after changing the script?

[#3]

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?

[Gysbert_Wassenaar]

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.

[#5]

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;

[marcus_malinow · Accepted solution]

Jon,

you don't have IslandDate.

You are loading it but renaming it to OrderDate.

'IslandDate AS OrderDate'

Marcus

[#7]

Thanks.