| IOtherTotalSpecProp Properties |
The IOtherTotalSpecProp type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | ApplyEvenWhenPossiblyWrongResult | Set this parameter to true to allow the calculation of Others even if the engine detects some potential mistakes.
For example the country Russia is part of the continent Europe and Asia. If you have an hypercube with two dimensions Country and Continent and one measure Population, the engine can detect that the population of Russia is included in both the continent Asia and Europe.
The default value is true. |
| ForceBadValueKeeping | This parameter is used when qOtherMode is set to:
OTHER_ABS_LIMITED
OTHER_REL_LIMITED
OTHER_ABS_ACC_TARGET
OTHER_REL_ACC_TARGET
and when the dimension values include not numeric values.
Set this parameter to true to include text values in the returned values.
The default value is true. |
| GlobalOtherGrouping | This parameter applies to inner dimensions.
If this parameter is set to true, the restrictions are calculated on the selected dimension only. All previous dimensions are ignored.
The default value is false. |
| OtherCollapseInnerDimensions | If set to true, it collapses the inner dimensions (if any) in the group Others.
The default value is false. |
| OtherCounted | Number of values to display. The number of values can be entered as a calculated formula.
This parameter is used when qOtherMode is set to OTHER_COUNTED. |
| OtherLimit | Value used to limit the dimension values. The limit can be entered as a calculated formula.
This parameter is used when qOtherMode is set to:
OTHER_ABS_LIMITED
OTHER_REL_LIMITED
OTHER_ABS_ACC_TARGET
OTHER_REL_ACC_TARGET
|
| OtherLimitMode | Sets the limit for the Others mode.
This parameter is used when qOtherMode is set to:
OTHER_ABS_LIMITED
OTHER_REL_LIMITED
OTHER_ABS_ACC_TARGET
OTHER_REL_ACC_TARGET |
| OtherMode | Determines how many dimension values are displayed.
The default value is OTHER_OFF. |
| OtherSortMode | Defines the sort order of the dimension values.
The default value is OTHER_SORT_DESCENDING. |
| ReferencedExpression | This parameter applies when there are several measures.
Name of the measure to use for the calculation of Others for a specific dimension. |
| SuppressOther | If set to true,the group Others is not displayed as a dimension value.
The default value is false. |
| TotalMode | If set to TOTAL_EXPR, the total of the dimension values is returned.
The default value is TOTAL_OFF. |
See Also