PivotGridXmlaDataSource Class
A datasource used to access OLAP data via XMLA.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v21.1.Core.dll
NuGet Package: DevExpress.PivotGrid.Core
Declaration
Remarks
The PivotGridXmlaDataSource class is obsolete. To bind a pivot grid to an OLAP cube via the XMLA data access standard, set the pivot grid’s OLAPDataProvider property to XMLA and assign the connection string to the OLAPConnectionString property (see the example below).
To learn more, see Binding to OLAP Data Sources.
Tip
You need an IIS server with a data pump configured on it to serve as a proxy to bind a PivotGridControl to an OLAP server via XMLA.
Documentation: Configure HTTP Access to Analysis Services on IIS 8.0
Example
The following example demonstrates how to bind a PivotGridControl to an OLAP cube via the XMLA data access standard.
In this example, the PivotGridControl.OLAPDataProvider property is used to specify that the Pivot Grid Control should use the XMLA data access standard to bind to an OLAP cube. OLAP connection parameters are specified in a connection string passed to the PivotGridControl.OLAPConnectionString property. The following parameters are provided:
- Data Source - a path to a data pump.
- Initial Catalog - a data catalog that contains cubes.
- Cube Name - the name of the cube that provides OLAP data.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/how-to-bind-to-an-olap-cube-via-xmla-e3708
using System;
using System.Windows.Forms;
using DevExpress.XtraPivotGrid;
namespace XtraPivotGrid_XMLA {
public partial class Form1 : Form {
public Form1() {
InitializeComponent();
}
void Form1_Load(object sender, EventArgs e) {
// Specifies that PivotGridControl should use the XMLA data access standard
// to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Xmla;
// Configures a data connection.
// Specifies a string that encapsulates connection parameters
// required to access the desired OLAP cube.
pivotGridControl1.OLAPConnectionString =
"Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" +
"Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works";
}
}
}