SSIS - SSAS: Missing data handling

by SGuard   Last Updated October 03, 2017 23:06 PM

I have a solution in SSDT with a SSIS and a SSAS project, with missing values in both numeric and text columns.

Is it a good practice converting all the missing values of these columns to NULL during SSIS and then handle in SSAS?

Is there a way to ignore all NULL entries during every query in a SSAS OLAP Cube, besides defining calculated measures etc. for each possible query?



Related Questions


SSIS / SSAS: Handling Age Columns

Updated October 05, 2017 02:06 AM

Q: Null Dimensions in SSAS

Updated June 03, 2015 22:02 PM



SSIS - SSAS Handling String Representation Values

Updated October 03, 2017 22:06 PM