PivotCustomizationExtension.BindToOLAP(String) Method

Binds the PivotCustomizationExtension to an OLAP cube.

Namespace : DevExpress.Web.Mvc

Assembly : DevExpress.Web.Mvc5.v25.2.dll

NuGet Package : DevExpress.Web.Mvc5

Declaration

• C#
• VB.NET

public PivotCustomizationExtension BindToOLAP(
    string connectionString
)

Public Function BindToOLAP(
    connectionString As String
) As PivotCustomizationExtension

Parameters

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

|

Returns

A PivotCustomizationExtension object representing the PivotCustomizationExtension.

|

Remarks

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

PivotCustomizationExtension Class

PivotCustomizationExtension Members

DevExpress.Web.Mvc Namespace