Master Time Calendar

[mccook]

Hi,

I've created a master time calendar and linked this to my fact table, however for some reason the link is not working correctly (possibly because the time in both fields is in a different format, although they look the same) so the start time hour, start time minute etc are not linked to the appropriate lines in the fact table.

I've attached a sample of the data.

Any help appreciated.

Cheers,

Dean

[Anonymous · Accepted solution]

Dean

I've rounded your join fields to the nearest second & things look better.

[mccook]

Looks good to me,

Many thanks,

Dean