PivotCustomizationExtension.BindToOLAP(String) Method

Binds the PivotCustomizationExtension to an OLAP cube.

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v20.1.dll


public PivotCustomizationExtension BindToOLAP(
    string connectionString
Public Function BindToOLAP(
    connectionString As String
) As PivotCustomizationExtension


Name Type Description
connectionString String

A String that specifies the connection string to an OLAP cube.


Type Description

A PivotCustomizationExtension object representing the PivotCustomizationExtension.


Bind the PivotCustomizationExtension to the same datasource as the PivotGrid to fetch the collection of fields from the datasource via the ASPxPivotGrid.RetrieveFields method (MVCxPivotGrid.RetrieveFields). If you add fields manually to the PivotGridSettings.Fields collection, there is no need to bind the PivotCustomizationExtension to data.

A sample OLAP connection string is shown below:

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

This connection string provides 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);
  • 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 number of seconds to wait until a query to SSAS is completed. If this parameter is set to 0, each query can last indefinitely.
See Also