I have created a Time dimension table, which has a column containing all dates between 2000 and 2004. I have created a Shared Time dimension based on this table using the default Time dimension functionality provided in Analysis Manager. The Time dimension was added to my cube, wherein I have defined the join between a Fact table column and the time dimension table. On adding the Time dimension to the cube, the measures values are going wrong.

The reason for incorrect measure values is because
a. Some Fact table rows are somehow getting ignored.
b. The rows getting ignored in the cube building are those that point to another dimension which has two Date columns with Null values.(i.e. Measure values from Fact table rows that are related to dimension table with non-null date column values are getting into the cube).

Does having Null values in “date” datatype columns in dimension tables affect the Time dimension (even when there is no join specified between those Date columns and the Fact table or Time dimension table)?