[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.DashboardWpf
  [Expand]DevExpress.Data
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.FilteringUI
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Dialogs
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DataPager
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Native
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Collapse]DevExpress.Xpf.PivotGrid
    AllowHideFieldsType Enumeration
    AsyncCompletedHandler Delegate
   [Expand]AsyncOperationResult Class
   [Expand]CellElement Class
   [Expand]CellElementData Class
   [Expand]CellInfo Class
   [Expand]ColorScaleFormatCondition Class
    CopyCollapsedValuesMode Enumeration
    CopyMultiSelectionMode Enumeration
   [Expand]CustomPrefilterDisplayTextEventArgs Class
    CustomPrefilterDisplayTextEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
   [Expand]DataAreaElement Class
   [Expand]DataAreaElementData Class
   [Expand]DataBarFormatCondition Class
    DataFieldArea Enumeration
    DataProcessingEngine Enumeration
   [Expand]DefaultMenuItemNames Class
   [Expand]EventArgsToCellInfoConverter Class
   [Expand]EventArgsToFieldValueInfoConverter Class
   [Expand]ExpressionConditionBase Class
    FieldAllowedAreas Enumeration
    FieldArea Enumeration
    FieldBestFitArea Enumeration
    FieldColumnTotalsLocation Enumeration
    FieldFilterType Enumeration
   [Expand]FieldFilterValues Class
    FieldGroupInterval Enumeration
    FieldListAllowedLayouts Enumeration
    FieldListArea Enumeration
   [Expand]FieldListControlBase Class
    FieldListLayout Enumeration
    FieldListOrientation Enumeration
    FieldListStyle Enumeration
    FieldOLAPFilterUsingWhereClause Enumeration
    FieldPropertyName Enumeration
    FieldRowTotalsLocation Enumeration
    FieldSortBySummaryOrder Enumeration
    FieldSortLocation Enumeration
    FieldSortMode Enumeration
    FieldSortOrder Enumeration
    FieldSummaryDisplayType Enumeration
    FieldSummaryType Enumeration
    FieldTopValueMode Enumeration
    FieldTopValueType Enumeration
    FieldTotalsVisibility Enumeration
    FieldUnboundColumnType Enumeration
    FieldUnboundExpressionMode Enumeration
   [Expand]FieldValueCell Class
   [Expand]FieldValueElement Class
   [Expand]FieldValueElementData Class
   [Expand]FieldValueInfo Class
    FieldValueType Enumeration
   [Expand]FormatCondition Class
   [Expand]FormatConditionBase Class
   [Expand]FormatConditionCollection Class
   [Expand]FormatConditionCommandParameters Class
   [Expand]GroupChangedEventArgs Class
    GroupChangedEventHandler Delegate
    GroupChangeType Enumeration
    GroupFilterMode Enumeration
   [Expand]GroupFilterValue Class
   [Expand]GroupFilterValues Class
   [Expand]GroupFilterValuesCollection Class
   [Expand]IconSetFormatCondition Class
   [Expand]IndicatorFormatConditionBase Class
   [Expand]IThreadSafeField Interface
   [Expand]LightweightCellElement Class
   [Expand]LightweightFieldValueElement Class
    OlapDataProvider Enumeration
   [Expand]PivotBrushChangedEventArgs Class
    PivotBrushChangedEventHandler Delegate
    PivotBrushType Enumeration
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellEventArgs Class
    PivotCellEventHandler Delegate
   [Expand]PivotCellValueEventArgs Class
    PivotCellValueEventHandler Delegate
    PivotChartDataProvideMode Enumeration
    PivotChartDataProvidePriority Enumeration
   [Expand]PivotChartDataSourceRow Class
    PivotChartExportFieldValueMode Enumeration
    PivotChartFieldValuesProvideMode Enumeration
    PivotChartItemDataMember Enumeration
    PivotChartItemType Enumeration
   [Expand]PivotCustomCellAppearanceEventArgs Class
    PivotCustomCellAppearanceEventHandler Delegate
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomFieldDataEventArgs Class
    PivotCustomFieldDataEventHandler Delegate
   [Expand]PivotCustomFieldListSortEventArgs Class
   [Expand]PivotCustomFieldSortEventArgs Class
    PivotCustomFieldSortEventHandler Delegate
   [Expand]PivotCustomFieldValueCellsEventArgs Class
    PivotCustomFieldValueCellsEventHandler Delegate
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
    PivotCustomFilterPopupItemsEventHandler Delegate
   [Expand]PivotCustomGroupIntervalEventArgs Class
    PivotCustomGroupIntervalEventHandler Delegate
   [Expand]PivotCustomSummaryEventArgs Class
    PivotCustomSummaryEventHandler Delegate
   [Expand]PivotCustomValueAppearanceEventArgs Class
    PivotCustomValueAppearanceEventHandler Delegate
    PivotDefaultMemberFields Enumeration
   [Expand]PivotDrillDownDataRow Class
   [Expand]PivotDrillDownDataSource Class
   [Expand]PivotExcelFieldListControl Class
   [Expand]PivotFieldAreaChangingEventArgs Class
    PivotFieldAreaChangingEventHandler Delegate
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldListControl Class
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldValueCancelEventArgs Class
    PivotFieldValueCancelEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFilterEditorEventArgs Class
    PivotFilterEditorEventHandler Delegate
   [Expand]PivotGridCellMenuInfo Class
   [Expand]PivotGridCommands Class
   [Collapse]PivotGridControl Class
     PivotGridControl Members
     PivotGridControl Constructor
    [Collapse]PivotGridControl Properties
      ActiveFilterInfo Property
      AllowConditionalFormattingManager Property
      AllowConditionalFormattingMenu Property
      AllowCrossGroupVariation Property
      AllowCustomizationForm Property
      AllowDrag Property
      AllowDragInCustomizationForm Property
      AllowExpand Property
      AllowExpandOnDoubleClick Property
      AllowFilter Property
      AllowFilterInFieldList Property
      AllowHideFields Property
      AllowMRUFilterList Property
      AllowPrefilter Property
      AllowResizing Property
      AllowSort Property
      AllowSortBySummary Property
      AllowSortInFieldList Property
      AutoExpandGroups Property
      BestFitArea Property
      BestFitMaxRowCount Property
      BestFitMode Property
      CanEnablePrefilter Property
      CellBackground Property
      CellForeground Property
      CellMenuCustomizations Property
      CellSelectedBackground Property
      CellSelectedForeground Property
      CellStyle Property
      CellTotalBackground Property
      CellTotalForeground Property
      CellTotalSelectedBackground Property
      CellTotalSelectedForeground Property
      ChartAutoTranspose Property
      ChartDataProvideMode Property
      ChartDataProvidePriority Property
      ChartDataSource Property
      ChartFieldValuesProvideMode Property
      ChartMaxPointCountInSeries Property
      ChartMaxSeriesCount Property
      ChartProvideCellValuesAsType Property
      ChartProvideColumnCustomTotals Property
      ChartProvideColumnFieldValuesAsType Property
      ChartProvideColumnGrandTotals Property
      ChartProvideColumnTotals Property
      ChartProvideDataByColumns Property
      ChartProvideEmptyCells Property
      ChartProvideRowCustomTotals Property
      ChartProvideRowFieldValuesAsType Property
      ChartProvideRowGrandTotals Property
      ChartProvideRowTotals Property
      ChartSelectionOnly Property
      ChartUpdateDelay Property
      ClipboardCopyCollapsedValuesMode Property
      ClipboardCopyMultiSelectionMode Property
      ColumnCount Property
      ColumnFieldValuesAlignment Property
      ColumnTotalsLocation Property
      ConditionalFormattingManagerServiceTemplate Property
      CopyToClipboardWithFieldValues Property
      Data Attached Property
      DataFieldArea Property
      DataFieldAreaIndex Property
      DataFieldCaption Property
      DataFieldHeight Property
      DataFieldUnboundExpressionMode Property
      DataFieldWidth Property
      DataHeadersDisplayMode Property
      DataProcessingEngine Property
      DataSource Property
      DefaultDataProcessingEngine Property
      DeferredUpdates Property
      DrawFocusedCellRect Property
      DrillDownCustomColumns Property
      DrillDownMaxRowCount Property
      ErrorPanelStyle Property
      ErrorPanelText Property
      ExcelFieldListState Property
      ExcelFieldListTemplate Property
      ExpressionEditorContainer Property
      FieldCellKpiTemplate Property
      FieldCellKpiTemplateSelector Property
      FieldCellTemplate Property
      FieldCellTemplateSelector Property
      FieldGeneratorStyle Property
      FieldGeneratorTemplate Property
      FieldGeneratorTemplateSelector Property
      FieldHeaderContentStyle Property
      FieldHeaderDragIndicatorSize Attached Property
      FieldHeaderDragIndicatorTemplate Property
      FieldHeaderListTemplate Property
      FieldHeaderListTemplateSelector Property
      FieldHeaderTemplate Property
      FieldHeaderTemplateSelector Property
      FieldHeaderTreeViewTemplate Property
      FieldHeaderTreeViewTemplateSelector Property
      FieldHeight Property
      FieldListAllowedLayouts Property
      FieldListFactory Property
      FieldListIncludeVisibleFields Property
      FieldListLayout Property
      FieldListSplitterX Property
      FieldListSplitterY Property
      FieldListState Property
      FieldListStyle Property
      FieldListTemplate Property
      Fields Property
      FieldsSource Property
      FieldValueMenuCustomizations Property
      FieldValueStyle Property
      FieldValueTemplate Property
      FieldValueTemplateSelector Property
      FieldWidth Property
      FilterByVisibleFieldsOnly Property
      FixedRowHeaders Property
      FocusedCell Property
      FocusedCellBorderTemplate Property
      FormatConditionDialogServiceTemplate Property
      FormatConditionGeneratorTemplate Property
      FormatConditionGeneratorTemplateSelector Property
      FormatConditions Property
      FormatConditionsSource Property
      GridMenu Property
      GroupDataCaseSensitive Property
      GroupFieldsInFieldList Property
      GroupFilterMode Property
      GroupGeneratorStyle Property
      GroupGeneratorTemplate Property
      GroupGeneratorTemplateSelector Property
      Groups Property
      GroupsSource Property
      HeaderAreaMenuCustomizations Property
      HeaderMenuCustomizations Property
      HiddenFields Property
      IsAsyncInProgress Property
      IsCellMenuEnabled Property
      IsErrorPanelVisible Property
      IsFieldListMenuEnabled Property
      IsFieldListVisible Property
      IsFieldValueMenuEnabled Property
      IsFilterPopupMenuEnabled Property
      IsFilterPopupWaitIndicatorVisible Property
      IsHeaderAreaMenuEnabled Property
      IsHeaderMenuEnabled Property
      IsLoading Property
      IsMainWaitIndicatorVisible Property
      IsPrefilterEnabled Property
      IsPrefilterVisible Property
      IsUpdateLocked Property
      LeftTopCoord Property
      LeftTopPixelCoord Property
      LoadingPanelDelay Property
      MergeColumnFieldValues Property
      MergeRowFieldValues Property
      MRUFilterListCount Property
      MRUFilters Property
      MultiSelection Property
      OlapConnectionString Property
      OlapDataProvider Property
      OlapDefaultMemberFields Property
      OlapFilterByUniqueName Property
      OlapModificationCheckInterval Property
      OlapServerDefinedDrillDownColumns Property
      OlapSortUsingDiscoverXmlMetadata Property
      OptimizeSummaryTypeCalculation Property
      PivotGrid Attached Property
      PredefinedColorScaleFormats Property
      PredefinedDataBarFormats Property
      PredefinedFormats Property
      PredefinedIconSetFormats Property
      PrefilterContainer Property
      PrefilterControl Property
      PrefilterCriteria Property
      PrefilterPanelText Property
      PrefilterString Property
      PrintCellBackground Property
      PrintCellForeground Property
      PrintCellTotalBackground Property
      PrintCellTotalForeground Property
      PrintColumnHeaders Property
      PrintDataHeaders Property
      PrintFieldCellKpiTemplate Property
      PrintFieldCellKpiTemplateSelector Property
      PrintFieldCellTemplate Property
      PrintFieldCellTemplateSelector Property
      PrintFieldHeaderTemplate Property
      PrintFieldHeaderTemplateSelector Property
      PrintFieldValueTemplate Property
      PrintFieldValueTemplateSelector Property
      PrintFilterHeaders Property
      PrintHeadersOnEveryPage Property
      PrintHorzLines Property
      PrintInsertPageBreaks Property
      PrintLayoutMode Property
      PrintRowHeaders Property
      PrintUnusedFilterFields Property
      PrintValueBackground Property
      PrintValueForeground Property
      PrintValueTotalBackground Property
      PrintValueTotalForeground Property
      PrintVertLines Property
      ResizingIndicatorTemplate Property
      RowCount Property
      RowFieldValuesAlignment Property
      RowTotalsHeightFactor Property
      RowTotalsLocation Property
      RowTreeHeight Property
      RowTreeMinHeight Property
      RowTreeMinWidth Property
      RowTreeOffset Property
      RowTreeWidth Property
      ScrollingMode Property
      ScrollViewerTemplate Property
      SelectedCellInfo Property
      Selection Property
      SelectMode Property
      ShowBorder Property
      ShowColumnGrandTotalHeader Property
      ShowColumnGrandTotals Property
      ShowColumnHeaders Property
      ShowColumnsBorder Property
      ShowColumnTotals Property
      ShowCustomTotalsForSingleValues Property
      ShowDataHeaders Property
      ShowFilterHeaders Property
      ShowGrandTotalsForSingleValues Property
      ShowLoadingPanel Property
      ShowOnlyAvailableFilterItems Property
      ShowPrefilterPanel Property
      ShowPrefilterPanelMode Property
      ShowRowGrandTotalHeader Property
      ShowRowGrandTotals Property
      ShowRowHeaders Property
      ShowRowTotals Property
      ShowTotalsForSingleValues Property
      SortBySummaryDefaultOrder Property
      SummaryDataSourceFieldNaming Property
      UseAsyncMode Property
      UseLightweightTemplates Property
      UserAction Property
      ValueBackground Property
      ValueForeground Property
      ValueSelectedBackground Property
      ValueSelectedForeground Property
      ValueTotalBackground Property
      ValueTotalForeground Property
      ValueTotalSelectedBackground Property
      ValueTotalSelectedForeground Property
    [Expand]PivotGridControl Events
    [Expand]PivotGridControl Methods
   [Expand]PivotGridCsvExportOptions Class
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldValueMenuInfo Class
   [Expand]PivotGridFilterPopupMenuInfo Class
   [Expand]PivotGridGroup Class
   [Expand]PivotGridGroupCollection Class
   [Expand]PivotGridHeaderMenuInfo Class
   [Expand]PivotGridHeadersAreaMenuInfo Class
   [Expand]PivotGridMenuInfo Class
    PivotGridMenuType Enumeration
   [Expand]PivotGridXlsExportOptions Class
   [Expand]PivotGridXlsxExportOptions Class
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
    PivotKpiGraphic Enumeration
    PivotKpiType Enumeration
   [Expand]PivotLayoutAllowEventArgs Class
    PivotLayoutAllowEventHandler Delegate
   [Expand]PivotLayoutUpgradeEventArgs Class
    PivotLayoutUpgradeEventHandler Delegate
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotOlapKpiMeasures Class
   [Expand]PivotOlapKpiValue Class
   [Expand]PivotOlapMember Class
   [Expand]PivotPropertyChangedEventArgs Class
    PivotPropertyChangedEventHandler Delegate
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
   [Expand]PivotSerializationOptions Class
   [Expand]PivotSummaryDataRow Class
   [Expand]PivotSummaryDataSource Class
   [Expand]PivotUnboundExpressionEditorEventArgs Class
    PivotUnboundExpressionEditorEventHandler Delegate
   [Expand]PopupMenuShowingEventArgs Class
    PopupMenuShowingEventHandler Delegate
    ScrollingMode Enumeration
    SelectMode Enumeration
    ShowPrefilterPanelMode Enumeration
   [Expand]SortByCondition Class
   [Expand]SortByConditionCollection Class
    StoreLayoutMode Enumeration
   [Expand]TopBottomRuleFormatCondition Class
    UnboundExpressionMode Enumeration
    UseLightweightTemplates Enumeration
    UserAction Enumeration
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.Scheduling.VisualData
  [Expand]DevExpress.Xpf.SpellChecker
  [Expand]DevExpress.Xpf.Spreadsheet
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Printing
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

PivotGridControl.OlapDataProvider Property

Gets or sets which data provider should be used to bind to an OLAP cube. This is a dependency property.

Namespace:DevExpress.Xpf.PivotGrid
Assembly:DevExpress.Xpf.PivotGrid.v18.2.dll

Expanded Syntax

Property value

Type: OlapDataProvider
An OlapDataProvider enumeration member that specifies which data provider should be used to bind to an OLAP cube.

Expanded Remarks

PivotGridControl can use one of the following data providers to communicate with the Microsoft Analysis Services server.

  • OLE DB for OLAP

    Provides basic OLAP binding capabilities.

  • ADOMD.NET

    Offers certain performance gains when compared to OLE DB, and yet allows you to retrieve OLAP member format strings and properties from the server.

  • XMLA

    An open XML-based standard that does not require any data access libraries or data providers to be installed on the client system. Nevertheless, it supports all OLAP features available in OLE DB and ADOMD.NET.

The default data provider for DXPivotGrid for WPF is OLE DB.

Expanded See Also

Is this topic helpful?​​​​​​​