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.