PivotGridControl.OlapConnectionString Property

Gets or sets a connection string to a cube in an MS Analysis Services database.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v14.2.dll

Declaration

C#

public string OlapConnectionString { get; set; }

VB.NET

Public Property OlapConnectionString As String

Property Value

Type	Description
String	A String that specifies a connection string to a cube in an MS Analysis Services database.

Remarks

Use the OlapConnectionString property to specify the connection string in XAML. The PivotGridControl.OlapDataLoaded event notifies you when data is loaded.

In code, use the PivotGridControl.SetOlapConnectionStringAsync method instead. To determine when data is loaded, pass an AsyncCompletedHandler delegate to this method.

A sample connection string is shown below:

Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works;Query Timeout=100;

The connection string has the following parameters:

• Data Source - the path to the data pump.
• Initial Catalog - a data catalog that contains cubes.
• Cube Name - the name of a cube that provides OLAP data.
• Query Timeout (optional) - the number of seconds to wait until the query to SSAS is completed. If this parameter is set to 0, each query can last for an indefinite time.

To learn more, see Binding to an OLAP Server.