In the case of a pivot table, the measure or pseudo dimension should be defined as a top dimension. This property applies to pivot tables and stacked pivot tables. To enable the sorting by ascending or descending order in the values of a measure. An indentation is added to the beginning of each row. This property applies for pivot tables and allows to change the layout of the table. If set to true, the total (if any) is shown on the first row. 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. Maximum number of cells for an initial data fetch (set in qInitialDataFetch ) when in stacked mode ( qMode is K).

It implies that it is not possible to collapse any cells. If this property is set to true, the cells are always expanded.

The pseudo dimension is a top dimension.

The index 2 corresponds to the left dimension Product.

The index 1 corresponds to the left dimension City.

The property qInterColumnSortOrder is left empty.

Product and Category are top dimensions.

The index 2 corresponds to the left dimension City.

The index 1 corresponds to the pseudo dimension.

The index 0 corresponds to the left dimension Country.

Three left dimensions ( qNoOfLeftDims is set to 3).

One pseudo dimension in position 1 (the position is defined in qInterColumnSortOrder ).

Four dimensions in the following order: Country, City, Product and Category.

The index related to each left dimension depends on the position of the pseudo dimension (if any). due to unfulfilled calc condition on dimension level) is still counted in this context. In that case, all dimensions are left dimensions. Stacked pivot tables can only contain one measure.ĭefines the way the data are handled internally by the engine.Ī pivot table can contain several dimensions and measures whereas a stacked pivot table can contain several dimensions but only one measure.ĭefault value is -1. You can neither collapse/expand a pseudo dimension nor make any selections in it. Pseudo dimensions only apply for pivot tables with more than one measure.Ī pseudo dimension groups together the measures defined in a pivot table. The index of the pseudo-dimension (if any) is -1. By default, the pseudo-dimension (if any) is the most to the right in the array. The default sort order is the order in which the dimensions and measures have been defined in the hypercube. However, the names of higher-order hypercubes do not appear to be in common use for higher powers.Defines the sort order of the columns in the hypercube.Įxample: means that the first column to be sorted should be the column 1, followed by the column 0 and the column 2. As a result, the act of raising a number to 2 or 3 is more commonly referred to as ' squaring' and 'cubing', respectively. Similarly, the exponent 3 will yield a perfect cube, an integer which can be arranged into a cube shape with a side length of the base. For example, the exponent 2 will yield a square number or 'perfect square', which can be arranged into a square shape with a side length corresponding to that of the base. Generalized hypercubesĪny positive integer raised to another positive integer power will yield a third integer, with this third integer being a specific type of figurate number corresponding to an n-cube with a number of dimensions corresponding to the exponential.

A unit hypercube's longest diagonal in n dimensions is equal to n. It is a closed, compact, convex figure whose 1- skeleton consists of groups of opposite parallel line segments aligned in each of the space's dimensions, perpendicular to each other and of the same length. In geometry, a hypercube is an n-dimensional analogue of a square ( n = 2) and a cube ( n = 3). For the four-dimensional object known as 'the' hypercube, see Tesseract. For internetwork topology, see Hypercube internetwork topology. For the computer architecture, see Connection Machine. This article is about the mathematical concept.

Hypercube of suitable dimension