Handling NULL Values to Prevent Incomplete Aggregate Tables and Unexpected Query Results

When NULL key values are present in the relationship key column of either a fact table or dimension table it can result in incomplete aggregate tables and unexpected query results.

The optimal method of preventing incomplete aggregate tables and unexpected query results is to perform the data engineering necessary to prevent key columns from having NULL values.

If this is not feasible, ensure AtScale's Custom Empty Member setting is enabled on all related dimension levels.