ConsolidatedMax
ConsolidatedMax calculates the maximum value in a consolidation and returns that single value.
This function is valid in both rules and TurboIntegrator processes.
Syntax
ConsolidatedMax(flagvalue, cubename, element_1, element_2,… );
Arguments
 flagvalue
 The
flagvalue
is the sum of the following option values: 1  Use weighting when computing the value of consolidated values within the consolidation for
which you are determining the maximum. If this option value is not included in the
flagvalue
sum, the raw value of the consolidated element is used.The following conditions might affect whether zeros are included in the calculation.
 If zero is specified as the weighting of some consolidated elements, then the
Tm1s.cfg
configuration parameterZeroWeightOptimization=F
must be set for these elements to be included in the calculation of the maximum value in a consolidation. Without this configuration parameter, the elements for which the weighting is zero are eliminated from the consolidation list, and are therefore not included when calculating the maximum value in a consolidation.  If you want cells containing the value zero to be included when calculating the average,
UNDEFVALS
must be set in the rules for the cube that is specified by thecubename
argument. This ensures that when a zero is assigned to a cell of the cube, an actual zero value is stored in the cell and the zero value is included when calculating the maximum value in a consolidation.  If the rules for the cube that is specified by the
cubename
argument include aSKIPCHECK
statement, zeros are always ignored when calculating the maximum value in a consolidation. Remove theSKIPCHECK
statement from the rule to include zeros in the calculation of the maximum value.
 If zero is specified as the weighting of some consolidated elements, then the
 2  Ignore zero values. If this value is included in the
flagvalue
sum, zero values will not be included in the calculation of the maximum value in a consolidation.
There are three valid values forflagvalue
. 1  Use consolidation weighting when computing the maximum value in a consolidation.
 2  Ignore zero values when computing the maximum value in a consolidation.
 3  Use consolidation weighting and ignore zero values when computing the maximum value in a consolidation.
 1  Use weighting when computing the value of consolidated values within the consolidation for
which you are determining the maximum. If this option value is not included in the
 cubename

Name of the cube where the values reside.
If the function is running as part of a cube rule, and NOT as part of a TurboIntegrator process, the cubename argument can be specified as an empty string to mean the current cube. This means you may write a rule such as:
['Apr']=ConsolidatedMax( 1, '', !actvsbud, '1 Quarter' );
 element_1, element_2, …

Dimension element names that define the intersection of the cube containing the consolidation for which you want to determine the maximum value.
Arguments element_1 through element_n are sequencesensitive. element_1 must be an element from the first dimension of the cube, element_2 must be an element from the second dimension, and so on. These arguments can also be the names of aliases for dimension elements or TurboIntegrator variables.
Example
Consider a cube called Income Statement with three dimensions, "Area", "Time", and "Income Statement". The Income Statement dimension contains an element "Gross Sales" for the overall sales number.
To calculate the maximum sales across all regions in the year 2010 use:
ConsolidatedMax( 1, 'Income Statement', 'All Regions', '2010', 'Gross Sales' );