NoOfLeftDims Property
Overloads
NoOfLeftDims |
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
* Three left dimensions ( implies that: * 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. Another example: * Four dimensions in the following order: Country, City, Product and Category. * Three left dimensions ( * One pseudo dimension. * The property Implies that: * 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. JSON property name: qNoOfLeftDims |
NoOfLeftDims
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
Declaration
int NoOfLeftDims { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 |
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!