ITreeDataDef Interface

Specifies a calculation condition object.

If CalcCondition.Cond is not fulfilled, the TreeData is excluded from the calculation and CalcCondition.Msg is evaluated.

By default, there is no calculation condition.

This property is optional.

JSON property name: qCalcCondition

Set Expression valid for the whole cube. Used to limit computations to the set specified.

JSON property name: qContextSetExpression

Array of dimensions.

JSON property name: qDimensions

Expansion state per dimension.

JSON property name: qExpansionState

Initial data set.

This property is optional.

JSON property name: qInitialDataFetch

Defines the order of the dimension levels/columns in the TreeData object.

Column numbers are separated by a comma.

Example: [1,0,2] means that the first level in the tree structure is dimension 1, followed by dimension 0 and dimension 2.

The default sort order is the order in which the dimensions and measures have been defined in the TreeDataDef.

JSON property name: qInterColumnSortOrder

If this property is set to true, the cells are opened expanded. The default value is false.

JSON property name: qOpenFullyExpanded

If this property is set to true, the missing symbols (if any) are replaced by 0 if the value is a numeric and by an empty string if the value is a string.

The default value is false.

JSON property name: qPopulateMissing

Name of the alternate state.

Default is current selections $ .

JSON property name: qStateName

Removes missing values.

JSON property name: qSuppressMissing

Removes zero values.

JSON property name: qSuppressZero

Title of the TreeData object, for example the title of a chart.

JSON property name: qTitle

List of measures to calculate on the whole tree.

JSON property name: qValueExprs