ASPxPivotGrid.OLAPConnectionString Property

Specifies a connection string to a cube in an MS Analysis Services database.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v19.2.dll

Declaration

C#

[DefaultValue("")]
public string OLAPConnectionString { get; set; }

VB.NET

<DefaultValue("")>
Public Property OLAPConnectionString As String

Property Value

Type	Default	Description
String	String.Empty	A connection string.

Remarks

A sample connection string is shown below:

OlapConnectionString=”Provider=msolap;Data Source=localhost;Initial Catalog=Adventure Works DW;Cube Name=Adventure Works;Query Timeout=100;”

The connection string has the following parameters:

• Provider - Identifies a data provider to be used. The “msolap” string identifies the latest version of Microsoft SQL Server Analysis Services (SSAS);

  Important

  Note that the Provider parameter is in effect only for the OLE DB provider for Analysis Services specified using the ASPxPivotGrid.OLAPDataProvider property.

• Data Source - Specifies the name of a server that runs an instance of SSAS;
• Initial Catalog - Specifies a data catalog that contains cubes;
• Cube Name - Specifies the name of a cube that provides OLAP data;
• Query Timeout (optional) - The maximum amount of time, in seconds, to wait for a query to SSAS to complete. If the parameter is set to 0, each query can last for an indefinite time.

Note

In order to enable a pivot grid’s ability to bind to OLAP data sources, the @ Page directive of a web page containing the pivot grid should include the AspCompat attribute, set to true.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the OLAPConnectionString property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-implement-sorting-by-summary-in-olap-mode-e3092/CS/ASPxPivotGrid_OLAPSortBySummary/Default.aspx.cs#L9

base.OnInit(e);
ASPxPivotGrid1.OLAPConnectionString = "provider=MSOLAP;" +
    "data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" +

VB.NET

how-to-implement-sorting-by-summary-in-olap-mode-e3092/VB/ASPxPivotGrid_OLAPSortBySummary/Default.aspx.vb#L11

MyBase.OnInit(e)
ASPxPivotGrid1.OLAPConnectionString = "provider=MSOLAP;" &
    "data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" &