- Using Optimize Totals does NOT trigger column or row optimization.
- Using Optimize Columns or Optimize Rows does NOT trigger the Optimize Totals feature.
- Optimize Totals can have a dramatic improvement on totaling performance and overall query speed.
- The NONEMPTY function will not be activated if there is only one hierarchy in the totals function.
The Optimize Total switch can be turned ON when needed for improving query results.
There are several ways to turn ON this optimization switch.