ConsolidatedMin
This is a TM1® Rules function, valid in Rules and TurboIntegrator processes.
Syntax
ConsolidatedMin(flag-value, cube-name, element_1, element_2,… );Arguments
- flag-value
The flag value is the sum of the following values:
1 - use consolidation weighting when computing the value. If this is not turned on the raw value of the consolidated element will be used.
2 - ignore zero values. If this is set, zero values will not be used by these functions.
Note: If zero is specified as the weighting of some consolidated elements, then the configuration parameter: ZeroWeightOptimization=F must be set for these elements to be factored into the computation of these functions. Without this configuration parameter, the elements for which the weighting is zero are eliminated from the consolidation list, and are therefore not processed when discovering things line the minimum or maximum value.- cube-name
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 Turbo Integrator process, the cube-name argument can be specified as an empty string to mean the current cube. This means you may write a rule such as:['Apr']=ConsolidatedMin( 1, '', !actvsbud, '1 Quarter' );
- element_1, element_2, …
Dimension element names that define the intersection of the cube containing the value to be retrieved.
Arguments element_1 through element_n are sequence-sensitive. 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.