This content has been marked as final. Show 2 replies
I have created a master calender in my script and renamed the primary key to the same name as the date field in my fact table. I have formatted the two dates in both tables to DD/MM/YYYY and removed the timestamp info from the end of the DD/MM/YYYY hh:mm:ss statement in my script declarations.
In my table viewer screen the two tables are linked correctly. (see attached image)
When i preview the data in both tables they both have dates in the fields in the correct formats and my Master calendar has entries for every day between the two dates I wanted.
However when I put a list box of Calendar Quarters, or Yeartodate etc or any field from the master calender, selecting the data in that list box will not return any data from the Facts table at all.
What am i missing here?