TreeDataDef

Defines the properties of a TreeData object. For more information about the definition of a TreeData object, see Generic object.

STABLE.
This API is reliable and breaking changes are unlikely.

Properties

Name	Description	Type
qStateName	Name of the alternate state. Default is current selections $ .	String
qDimensions	Array of dimensions.	Array of NxTreeDimensionDef
qInterColumnSortOrder	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.	Array of Integer
qSuppressZero	Removes zero values.	Boolean
qSuppressMissing	Removes missing values.	Boolean
qOpenFullyExpanded	If this property is set to true, the cells are opened expanded. The default value is false.	Boolean
qPopulateMissing	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.	Boolean
qCalcCondition		NxCalcCond
qTitle		StringExpr
qInitialDataFetch	Initial data set. This property is optional.	Array of NxTreeDataOption
qExpansionState	Expansion state per dimension.	Array of ExpansionData
qValueExprs	List of measures to calculate on the whole tree.	Array of NxMeasure
qContextSetExpression	Set Expression valid for the whole cube. Used to limit computations to the set specified.	String

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!