PivotGridXmlaDataSource Class

A data source used to access OLAP data via XMLA.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v14.2.Core.dll

Declaration

C#

public class PivotGridXmlaDataSource :
    OLAPDataSourceBase

VB.NET

Public Class PivotGridXmlaDataSource
    Inherits OLAPDataSourceBase

Remarks

The PivotGridXmlaDataSource class is obsolete. To bind a pivot grid to an OLAP cube via the XMLA data access standard, assign the connection string to the PivotGridControl.OlapConnectionString property in XAML (see the example below) or pass it to the PivotGridControl.SetOlapConnectionStringAsync method in code.

To learn more, see Binding to an OLAP Server.

NOTE

To bind a PivotGridControl to an OLAP server via XMLA, you will need an IIS server with a data pump configured on it to serve as a proxy. To learn how to set up an IIS server and a data pump, see How to Configure HTTP Access to SQL Server 2008 Analysis Services on IIS7.

Examples

The following example demonstrates how to bind a PivotGridControl to an OLAP cube via the XMLA data access standard.

In this example, 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 that was previously configured on an IIS server and will be used as a middle-ware component to access the datasource;
• Initial Catalog - a data catalog that contains cubes;
• Cube Name - the name of the cube that provides OLAP data.

To learn how to bind a pivot grid to an OLAP cube step-by-step, see Lesson 1 - Binding a Pivot Grid to an OLAP Cube.

Inheritance

Object

DevExpress.PivotGrid.QueryMode.QueryDataSource<DevExpress.PivotGrid.OLAP.OLAPCubeColumn>

OLAPDataSourceBase

PivotGridXmlaDataSource