OLAPDataProvider Enum

Lists values that specify which data provider should be used when binding to an OLAP cube.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[TypeConverter(typeof(EnumTypeConverter))]
[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum OLAPDataProvider

VB.NET

<TypeConverter(GetType(EnumTypeConverter))>
<ResourceFinder(GetType(ResFinder), "PropertyNamesRes")>
Public Enum OLAPDataProvider

Members

Name	Description
Default	The default OLAP provider (see the respective property description for details).
Adomd	The ADOMD.NET data provider.
OleDb	The OLE DB data provider.
Xmla	The XMLA data access standard.

Related API Members

The following properties accept/return OLAPDataProvider values:

Library	Related API Members
WinForms Controls	PivotGridControl.OLAPDataProvider
Reporting	XRPivotGrid.OLAPDataProvider
ASP.NET Web Forms Controls	ASPxPivotGrid.OLAPDataProvider
	PivotGridSettings.OLAPDataProvider

Remarks

Values listed by this enumeration are used to set the PivotGridControl.OLAPDataProvider property for XtraPivotGrid, and the ASPxPivotGrid.OLAPDataProvider property for ASPxPivotGrid.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the OLAPDataProvider enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-bind-to-an-olap-cube-using-the-adomdnet-data-provider-e3705/CS/XtraPivotGrid_ADOMD/Form1.cs#L14

// to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd;

how-to-bind-to-an-olap-cube-via-xmla-e3708/CS/XtraPivotGrid_XMLA/Form1.cs#L14

// to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Xmla;

how-to-connect-a-pivot-grid-to-an-olap-datasource-t344546/CS/WinOlapRetrieveFieldsExample/Form1.cs#L13

// Specifies the OLAP connection settings.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd;
pivotGridControl1.OLAPConnectionString =

VB.NET

how-to-bind-to-an-olap-cube-using-the-adomdnet-data-provider-e3705/VB/XtraPivotGrid_ADOMD/Form1.vb#L16

' to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd

how-to-bind-to-an-olap-cube-via-xmla-e3708/VB/XtraPivotGrid_XMLA/Form1.vb#L16

' to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Xmla

how-to-connect-a-pivot-grid-to-an-olap-datasource-t344546/VB/WinOlapRetrieveFieldsExample/Form1.vb#L12

' Specifies the OLAP connection settings.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd
pivotGridControl1.OLAPConnectionString = "Provider=MSOLAP;" & ControlChars.CrLf & _