PivotCustomizationExtension.BindToOLAP(String) Method
Binds the PivotCustomizationExtension to an OLAP cube.
Namespace: DevExpress.Web.Mvc
Assembly: DevExpress.Web.Mvc5.v24.1.dll
NuGet Package: DevExpress.Web.Mvc5
Declaration
Parameters
| Name | Type | Description |
|---|---|---|
| connectionString | String | A String that specifies the connection string to an OLAP cube. |
Returns
| Type | Description |
|---|---|
| PivotCustomizationExtension | 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.