HyperCube
Renders the properties of a hypercube. Is the layout for HyperCubeDef. For more information about the definition of a hypercube, see Generic object.
What is returned in HyperCube depends on the type of the hypercube (straight, pivot or stacked table, or tree) and on the method called (GetLayout, GetHyperCubeData, GetHyperCubePivotData, GetHyperCubeStackData, GetHyperCubeTreeData).
Properties
Name | Description | Type |
---|---|---|
qStateName |
Name of the alternate state. Default is current selections $ . |
String |
qSize | Size | |
qError | NxValidationError | |
qDimensionInfo |
Information on the dimension. |
Array of NxDimensionInfo |
qMeasureInfo |
Information on the measure. |
Array of NxMeasureInfo |
qEffectiveInterColumnSortOrder |
Sort order of the columns in the hypercube. Column numbers are separated by a comma. Example: [1,0,2] means that the first column to be sorted was the column 1, followed by the column 0 and the column 2. |
Array of Integer |
qGrandTotalRow |
Aggregate for measures of all values in the field. The result value depends on the qAggrFunc defined in HyperCubeDef. |
Array of NxCell |
qDataPages |
Set of data. Is empty if nothing has been defined in qInitialDataFetch in HyperCubeDef. |
Array of NxDataPage |
qPivotDataPages |
Set of data for pivot tables. Is empty if nothing has been defined in qInitialDataFetch in HyperCubeDef. |
Array of NxPivotPage |
qStackedDataPages |
Set of data for stacked tables. Is empty if nothing has been defined in qInitialDataFetch in HyperCubeDef. |
Array of NxStackPage |
qMode |
Information about the mode of the visualization. One of:
|
String |
qNoOfLeftDims |
Number of left dimensions. Default value is -1. The index related to each left dimension depends on the position of the pseudo dimension (if any). For example, a pivot table with:
implies that:
Another example:
implies that:
|
Integer |
qIndentMode |
Is used for pivot tables only. If set to true, the formatting of the results is slightly different. This property is optional. |
Boolean |
qLastExpandedPos | NxCellPosition | |
qHasOtherValues |
True if other row exists. |
Boolean |
qTitle |
Title of the hypercube, for example the title of a chart. |
String |
qTreeNodesOnDim |
The total number of nodes on each dimension (only applicable when qMode = T ). |
Array of Integer |
qCalcCondMsg |
The message displayed if calculation condition is not fulfilled. |
String |
qColumnOrder |
The order of the columns. |
Array of Integer |
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!