ASPxPivotGrid.OLAPConnectionString Property
Specifies a connection string to a cube in an MS Analysis Services database.
Namespace: DevExpress.Web.ASPxPivotGrid
Assembly: DevExpress.Web.ASPxPivotGrid.v23.2.dll
NuGet Package: DevExpress.Web
Declaration
[DefaultValue("")]
[PivotAPIMemberCategory(APICategory.OLAPSource)]
public string OLAPConnectionString { get; set; }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.