Null Checking for Analytical Engine

The Null Checking for Analytical Engine VLDB property determines whether or not null values are interpreted as zeros when the Analytical Engine calculates data.

The default option is for aggregation calculations to ignore nulls and for scalar calculations to treat null values as zero. Any projects that existed prior to upgrading metadata to MicroStrategy ONE retain their original VLDB property settings. See the Advanced Reporting Help. for more information on this setting.

Changes made to this VLDB setting can cause differences to appear in your data output. Metrics using count or average, metrics with dynamic aggregation set to count or average, as well as thresholds based on such metrics could be impacted by altered calculation behavior.

Levels at Which You Can Set This

Project, report, template, and metric