ComponentOne True DataControl 8.0

PivotQuery Property (TDataLite)

Returns a string, the text of a multidimensional query (MDX) that is currently active.

Syntax

TData.PivotQuery

Remarks

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

This property applies to Pivot mode. It returns a string, the text of a multidimensional query (MDX) that is currently active. The query can be generated automatically, if you set PivotRowDimensions/PivotColumnDimension/PivotMeasure and call PivotOpen, or it can be explicitly passed to PivotOpen as a parameter. In both cases, after PivotOpen call, the PivotQuery property returns the current query text. It is mostly needed for debugging purposes.

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

See Also

TDataLite Control