Enables or disables view consolidation optimization on the Planning Analytics database.

Parameter type: optional, static

Using this parameter improves the performance of calculating consolidated elements. By default, ViewConsolidationOptimization is enabled on the Planning Analytics database.

View consolidation optimization stores the consolidated values that use leaf element components on either the row or column axis. For example, consider the dimension structure Year, 1Quarter with values Jan, Feb, and Mar.

When either a row or column subset uses the Jan element, both the 1 Quarter and Year consolidations are calculated and stored for future reference. This improves performance but increases the amount of memory required for a given view.

To disable view consolidation optimization, add the following line to Planning Analytics database configuration: