PivotColumnDimension Property (TDataLite)

True DataControl 8.0 Reference> True DataControl Lite Control> TDataLite Control Properties> PivotColumnDimension Property (TDataLite)

Together with PivotRowDimensions and PivotMeasure, it constitutes the end-user query, determines the data retrieved from the decision cube and exposed in the TData hierarchical recordset.

Syntax

TData.PivotColumnDimension = string

Remarks

This property applies to Pivot mode.

Read/Write at run time. Unavailable at design time. Property applies to TDataLite control. Not available in TData control.

Before calling PivotOpen, this property must be set to the name of a dimension field. That dimension will be used for columns: every value of that dimension will generate a column. This way, columns form a crosstab representation of the chosen dimension field.

Unlike PivotRowDimensions, this property does not accept lists of fields, it must be set to the name of a single field.

For more information, see OLAP: Decision Support, Pivot Table.