Skip to main content Skip to complementary content

OtherTotalSpecProp

Properties

Name Description Type
qOtherMode

Determines how many dimension values are displayed.

The default value is OTHER_OFF.

One of:

  • OTHER_OFF; do not limit the number of dimension values
  • OTHER_COUNTED; limit the dimension values to a specified number defined in OtherTotalSpecProp.
  • OTHER_ABS_LIMITED; limit the dimension values to an absolute value defined in OtherTotalSpecProp.
  • OTHER_ABS_ACC_TARGET; return the dimension values that accumulate to an absolute value. All rows up to the current row are accumulated and the result is compared to the specified absolute value. The absolute value is defined in OtherTotalSpecProp.
  • OTHER_REL_LIMITED; limit the dimension values based on a percentage of the total. The total is the sum of all the dimension values. The percentage is defined in OtherTotalSpecProp.
  • OTHER_REL_ACC_TARGET; return the dimension values that accumulate to a percentage of the total. All rows up to the current row are accumulated and the result is compared to the total of the dimension values. A percentage is calculated. This percentage is compared to the specified percentage, defined in OtherTotalSpecProp.
qOtherCounted

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.

"qv": "<expression>"

Where

<expression> is a string.

qOtherLimit

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

 

"qv": "<expression>"

Where

<expression> is a string.

qOtherLimitMode

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

One of:

  • OTHER_GE_LIMIT; include the values greater or equal
  • OTHER_LE_LIMIT; include the values lower or equal
  • OTHER_GT_LIMIT; include the values strictly greater than
  • OTHER_LT_LIMIT; include the values strictly lower than

Default: OTHER_GT_LIMIT

qSuppressOther

If set to true, the group Others is not displayed as a dimension value.

The default value is false.

Boolean
qForceBadValueKeeping

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.

Boolean
qApplyEvenWhenPossiblyWrongResult

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.

Boolean
qGlobalOtherGrouping

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.

Boolean
qOtherCollapseInnerDimensions

If set to true, it collapses the inner dimensions (if any) in the group Others.

The default value is false.

Boolean
qOtherSortMode

Defines the sort order of the dimension values.

The default value is OTHER_SORT_DESCENDING.

One of:

  • OTHER_SORT_DEFAULT; sort by load order
  • OTHER_SORT_DESCENDING; sort by descending values
  • OTHER_SORT_ASCENDING; sort by ascending values
qTotalMode

If set to TOTAL_EXPR, the total of the dimension values is returned.

The default value is TOTAL_OFF.

One of:

  • TOTAL_OFF
  • TOTAL_EXPR
qReferencedExpression

This parameter applies when there are several measures.

Name of the measure to use for the calculation of Others for a specific dimension.

String

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!