cxPivotGridOLAPCreateConnectionString(string,TcxCustomPivotGridOLAPProviderClass,TcxLookAndFeel) Method

Invokes the connection string designer dialog that allows end-user to specify connection settings for OLAP cubes.

Declaration

function cxPivotGridOLAPCreateConnectionString(var ACube: string; AProviderClass: TcxCustomPivotGridOLAPProviderClass; ALookAndFeel: TcxLookAndFeel = nil): string;

Parameters

Name	Type
ACube	string
AProviderClass	TcxCustomPivotGridOLAPProviderClass
ALookAndFeel	TcxLookAndFeel

Returns

Type
string

Remarks

Call this function to prompt end-users for connection settings to:

• Cubes deployed on servers (Microsoft SQL Server 2000 Analysis Services, Microsoft SQL Server 2005 Analysis Services, Microsoft SQL Server 2008 Analysis Services, Microsoft SQL Server 2008 R2 Analysis Services, Microsoft SQL Server 2012 Analysis Services, or Microsoft SQL Server 2014 Analysis Services).

• Offline cube files (CUB files).

The cxPivotGridOLAPCreateConnectionString function returns a fully qualified connection string based on the settings specified by end-users. This string can be then assigned to the TcxPivotGridOLAPDataSource.ConnectionString property.

The ACube parameter returns the name of the cube to be connected using this connection string.

The ALookAndFeel parameter specifies the style to be applied to the designer.

The AProviderClass parameter specifies the class type (a TcxCustomPivotGridOLAPProvider descendant) of the provider to be used for data access.

The dialog to be invoked is determined by the ConnectionDesignerClass global constant.

Note

The second overloaded variant of the cxPivotGridOLAPCreateConnectionString function is deprecated. Use the first variant instead.