Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
in order to discard hh:mm:ss , you can use
load ... DayStart(OPENEDDATE) as OPENEDDATE ..
in order to discard hh:mm:ss , you can use
load ... DayStart(OPENEDDATE) as OPENEDDATE ..
Thanks Alex, that seems to have sorted out my issues perfectly!