[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Collapse]Binding to Data
     Binding to Data Overview
    [Expand]Data Source Configuration Wizard
    [Collapse]OLAP Data Source
      Binding to OLAP Data Sources
      OLAP Requirements and Limitations
    [Expand]Database Server Mode
     Unbound Fields
     Optimized Mode and Data Binding API
     Local Data Stores
     Asynchronous Mode
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

OLAP Requirements and Limitations

Expanded Supported OLAP Servers

The following OLAP servers are supported:

  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server 2005 Analysis Services
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2012 Analysis Services (Multi-dimensional mode)
  • Microsoft SQL Server 2014 Analysis Services (Multi-dimensional mode)
  • Microsoft SQL Server 2016 Analysis Services (Multi-dimensional mode)

  • Microsoft SQL Server Analysis Services 2008 requires Microsoft SQL Server 2008 Service Pack 1.
  • Microsoft SQL Server Analysis Services 2005 requires Microsoft SQL Server 2005 Service Pack 2.
  • Microsoft SQL Server Analysis Services 2000 requires SP4.
  • In Microsoft SQL Server Analysis Services 2000, the PivotGridControl does not support a cube's dimension members with DBNull values.

Expanded Data Provider Requirements and Limitations

To use the OLE DB and ADOMD.NET providers, the PivotGridControl requires the Microsoft Analysis Services OLE DB and Microsoft ADOMD.NET providers on the client machine. Refer to the Data providers used for Analysis Services connections document for more information.

The following limitations are in effect when you use OLE DB and ADOMD.NET providers:

  • The application should run in Single-Threaded Apartment (STA) mode if the OLE DB data provider is used to establish a connection to the Microsoft SQL Server 2000 Analysis Services.
  • When binding to local cubes, use either an OLE DB or ADOMD.NET provider. When one provider has established a connection, the other provider becomes unavailable in the scope of the current process. There is a common situation that results in an exception: an attempt to connect to a local cube using OLE DB provider followed by disconnection and another attempt to connect to the same cube (or another cube file in the same process) using ADOMD.NET provider.

Expanded OLAP Mode Limitations

The following features have limitations in OLAP mode:

The following Pivot Grid Control features are not supported in OLAP mode:

Expanded OLAP Culture Settings

When the ADOMD.NET data provider (specified via the PivotGridControl.OLAPDataProvider property) connects to an OLAP data source, the provider requests the value and formatted text from the OLAP server's cube. This information includes a format string and the culture information.


If the OLAP server does not provide culture information, the client's culture settings are used to format the value (except currency settings). The client's culture settings are also used if you use the PivotGridFieldBase.CellFormat property to specify the format. To use different culture settings to format values, handle the PivotGridControl.CustomCellDisplayText event.

Expanded See Also

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