ViewConsolidationOptimizationMethod

This parameter defines the method used to achieve view consolidation optimization when the ViewConsolidationOptimization parameter is enabled on the IBM® Cognos® TM1® server.

Parameter type: optional, static

There are two methods that ViewConsolidationOptimization can use to calculate and store consolidations: ARRAY or TREE. The ARRAY method stores consolidations in a temporary array. The TREE method stores consolidations in a tree.

ViewConsolidationOptimizationMethod should be set to TREE in most circumstances. This setting provides the best performance in normal operations and when data is sparse along the view axes.

In the uncommon circumstance when axes dimensions have just a few leaf elements rolling up to many consolidations, ViewConsolidationOptimizationMethod should be set to ARRAY.

To set this parameter, add the appropriate line to your configuration file:

ViewConsolidationOptimizationMethod=TREE

ViewConsolidationOptimizationMethod=ARRAY

If ViewConsolidationOptimizationMethod is not explicitly set in the Tm1s.cfg file, the ARRAY method is used by default.