NxTreeDimensionInfo

Corresponds to the label of the dimension that is selected. If the label is not defined then the field name is used.

Length of the longest value in the field.

Number of distinct field values.

Is set to true if the field is locked.

Sort indicator. The default value is no sorting. This parameter is optional.

One of:

• N or NX_SORT_INDICATE_NONE
• A or NX_SORT_INDICATE_ASC
• D or NX_SORT_INDICATE_DESC

Array of dimension labels. Contains the labels of all dimensions in a hierarchy group (for example the labels of all dimensions in a drill down group).

Index of the dimension that is currently in use. qGroupPos is set to 0 if there are no hierarchical groups (drill-down groups) or cycle groups.

Gives information on a field. For example, it can return the type of the field. Examples: key, text, ASCII

Binary format of the field.

One of:

• D or NX_DIMENSION_TYPE_DISCRETE
• N or NX_DIMENSION_TYPE_NUMERIC
• T or NX_DIMENSION_TYPE_TIME

If set to true, it inverts the sort criteria in the field.

Defines the grouping.

One of:

• N or GRP_NX_NONE
• H or GRP_NX_HIEARCHY
• C or GRP_NX_COLLECTION

If set to true, it means that the field is a semantic.

Sets the formatting of a field. The properties of qFieldAttributes and the formatting mechanism are described below.

Formatting mechanism

The formatting mechanism depends on the type set in qType, as shown below:

Type is DATE, TIME, TIMESTAMP or INTERVAL

The following applies:

• If a format pattern is defined in qFmt , the formatting is as defined in qFmt .
• If qFmt is empty, the formatting is defined by the number interpretation variables included at the top of the script ( TimeFormat , DateFormat , TimeStampFormat ).
• The properties qDec , qThou , qnDec , qUseThou are not used.

Type is INTEGER

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the formatting mechanism uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , no formatting is applied. The properties qDec , qThou , qnDec , qUseThou and the number interpretation variables defined in the script are not used .

Type is REAL

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , and if the value is almost an integer value (for example, 14,000012), the value is formatted as an integer. The properties qDec , qThou , qnDec , qUseThou are not used.
• If no format pattern is defined in qFmt , and if qnDec is defined and not 0, the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.
• If no format pattern is defined in qFmt , and if qnDec is 0, the number of decimals is 14 and the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is FIX

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
• If no format pattern is defined in qFmt , the properties qDec and qnDec are used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is MONEY

The following applies:

• If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of any script ( MoneyDecimalSep and MoneyThousandSep ).
• If no format pattern is defined in qFmt , the engine uses the number interpretation variables included at the top of the script ( MoneyDecimalSep and MoneyThousandSep ).

Type is ASCII

No formatting, qFmt is ignored.

This parameter is set to true if qNumFormat is set to U (unknown). The engine guesses the type of the field based on the field's definition.

Array of field names.

Minimum value.

Maximum value.

Is continuous axis used.

Is a cyclic dimension used.

Is derived field is used as a dimension.

A List of measures to be calculated on this TreeDimension.

List of attribute expressions.

List of attribute dimensions.

The message displayed if calculation condition is not fulfilled.

True if this is a calculated dimension.

If set to true, it means that the field always has one and only one selected value.

Refers to a dimension stored in the library.