Handling Wrong or Missing Dates in Tabular
User Rating: / 0
Written by Marco Russo   
Friday, 13 September 2013 22:19

In the traditional star schema design of a Data Mart, you replace a missing, unknown or wrong date in the fact table with a dummy value in the Date dimension table. In Tabular, handling a Date table requires an existing date and you cannot use a NULL date in a Date table. This article describes how to apply the NULL replacement in the fact table using views, without altering the relational structure of the Data Mart.




XL Cubed