Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[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
 [Collapse]Controls and Libraries
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Collapse]Binding to Data
     Binding to Data Overview
    [Expand]Items Source Configuration Wizard
    [Collapse]OLAP Data Source
      Binding to OLAP Data Sources
      Requirements and Limitations
    [Expand]Database Server Mode
     Unbound Fields
     Local Data Stores
     Asynchronous Mode
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]MVVM Enhancements
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Requirements and Limitations

This topic lists supported OLAP servers and describes data providers that need to be installed on client machines to establish an OLAP connection. You will also learn about pivot grid features that are not supported in OLAP mode.

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)
Note

  • When using MS SQL Server Analysis Services 2008, MS SQL Server 2008 Service Pack 1 is required.
  • When using MS SQL Server Analysis Services 2005, MS SQL Server 2005 Service Pack 2 is required.
  • When using MS SQL Server Analysis Services 2000, SP4 is required.
  • In MS SQL Server Analysis Services 2000, a cube's dimension members with DBNull values are not supported by the PivotGridControl.

Expanded Data Provider Requirements and Limitations

To use the OLE DB and ADOMD.NET providers, the PivotGridControl requires Microsoft Analysis Services OLE DB and Microsoft ADOMD.NET providers to be installed on the client machine. To learn more, see Data providers used for Analysis Services connections.

Note that the following limitations are applied when using OLE DB and ADOMD.NET providers.

  • Using an OLE DB data provider to establish a connection to a Microsoft SQL Server 2000 Analysis Services requires that the application should run in a Single-Threaded Apartment (STA) mode.
  • When binding to local cubes, use either an OLE DB or ADOMD.NET provider, but not both. After you have established a connection using one of the providers, the other becomes unavailable from the current process. For instance, if you try to connect to a local cube using OLE DB, then disconnect and connect again using ADOMD.NET to the same or another cube file from the same process, an exception will be thrown.

Expanded OLAP Mode Limitations

The following features have certain specifics in an OLAP mode:

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

Expanded See Also

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