Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

cxPivotGridOLAPCreateConnectionString(string,TcxCustomPivotGridOLAPProviderClass,TcxLookAndFeel) Method

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

#Declaration

Delphi
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.

See Also