Dundas BI allows you to apply various rules to control how you can handle null values and missing data in your data sets. If rows are missing from your data or have measure values that are null or missing, you can set up a ‘missing data rule’ to display them and optionally fill in their measure values.
The problem is that many are unclear about the various options available, mainly Source Nulls and Full Nulls. Let’s get into the details.
If you’d like to learn more, I’d recommend you go to my learning channel - Off the Charts (with Jeff).