Are you saying that 1) the Date dim table is missing dates (that is, does not include all dates), or are you saying that your query is attempting to select data at a different date granularity than exists within the Date dim table?

Thanks.

Bill