NoOfLeftDims Property

Number of left dimensions.

Default value is -1. In that case, all dimensions are left dimensions.

Hidden dimensions (e.g. due to unfulfilled calc condition on dimension level) is still counted in this context.

The index related to each left dimension depends on the position of the pseudo dimension (if any).

For example, a pivot table with:

• Four dimensions in the following order: Country, City, Product and Category.
• One pseudo dimension in position 1 (the position is defined in qInterColumnSortOrder )
• Three left dimensions ( qNoOfLeftDims is set to 3).
• The index 0 corresponds to the left dimension Country.
• The index 1 corresponds to the pseudo dimension.
• The index 2 corresponds to the left dimension City.
• Product and Category are top dimensions.
• Four dimensions in the following order: Country, City, Product and Category.
• Three left dimensions ( qNoOfLeftDims is set to 3).
• One pseudo dimension.
• The property qInterColumnSortOrder is left empty.
• The index 0 corresponds to the left dimension Country.
• The index 1 corresponds to the left dimension City.
• The index 2 corresponds to the left dimension Product.
• Category is a top dimension.
• The pseudo dimension is a top dimension.

qInterColumnSortOrder is (0,-1,1,2,3).

implies that:

Another example:

Implies that:

JSON property name: qNoOfLeftDims