PivotConnectionString Property (TDataLite)

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

Specifies connection to an OLAP server or an off-line OLAP cube file.

Syntax

TData.PivotConnectionString = string

Remarks

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

This property applies to Pivot mode. It accepts any OLAP data connection valid for ADOMD.Catalog object, see Microsoft ADO MD documentation for details. It can be a live on-line connection to an OLAP server, or a connection to an off-line cube file. For example, you can prepare a cube file in Microsoft Excel 2000, with PivotTable and PivotChart Wizard, see Tutorial 10 - OLAP - Decision Support, Pivot Table.

Example: TData1.PivotConnectionString = “Provider=msolap;DATA SOURCE=C:\OLAPCubes\orders.cub”

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