Skip to main content

XRPivotGrid.OLAPConnectionString Property

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

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v24.1.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

[DefaultValue(null)]
[SRCategory(ReportStringId.CatData)]
public string OLAPConnectionString { get; set; }

Property Value

Type Default Description
String null

A connection string.

Remarks

Use the OLAPConnectionString property to specify the connection string to a cube in an MS Analysis Services database. 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).
  • 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, waited until a query to SSAS completes. If the parameter is set to 0, each query can last for an indefinite time.

At design time, a connection string can be built via the Connection String Editor. To open it, select the XRPivotGrid in the Properties window, focus the cell corresponding to the OLAPConnectionString property, and click the ellipsis button.

To represent information from the bound cube, create specific PivotGrid’s fields, and bind them to the required fields in the data source. You can use the designer’s Fields Page to do this.

If the OLAPConnectionString property is set to a valid string, the value of the XRPivotGrid.DataSource property is cleared. Setting the XRPivotGrid.DataSource property to a valid object clears the OLAPConnectionString.

For more details, see Binding to OLAP Data Sources.

See Also