I have a problem with a join in my fact table with the master calendar! I have created a global master calendar with an autonumber key that i would like to have in my fact table.
I have used the key word "resident" in order to get the master calendar key in the fact and join, but the result im getting is a crossjoin with millions of records in my fact table, which is not what i want!
What am i doing wrong ??
Here is my code:
"ID MasterCalendar" Resident MasterCalendar;
Right Join // keep gives the same result as join
AutoNumberHash128(Day("Start Date"), Month("Start Date"),Year("Start Date")) as "ID CalendrierStart",
AutoNumberHash128(Day("End Date"), Month("End Date"),Year("End Date")) as "ID CalendarEnd",