PivotMeasure Property (TDataLite)

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

Constitutes the end-user query, determines the data retrieved from the decision cube and exposed in the TData hierarchical recordset.

Syntax

TData.PivotMeasure = string

Remarks

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

This property applies to Pivot mode. Together with PivotRowDimensions and PivotColumnDimension, it constitutes the end-user query, determines the data retrieved from the decision cube and exposed in the TData hierarchical recordset.

Before calling PivotOpen, this property must be set to the name of a measure field. Values of this measure are shown in the cells of the resulting hierarchical crosstab.

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