SQL SERVER SSAS: How do I handle a NULL date value in my fact table, so I can process my time dimens
- by dhz
Hello!
I have a a fact table that has a column with dates loaded from an MS Access source. The thing is, some of the values are NULL and the SSAS won't let me refer my DATE dimension to it.
Is it better to solve it at the SSIS stage or is there some solution at the SSAS?
Thank you very much for you help.