Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [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
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Collapse]Binding to Data
     Binding to Data Overview
    [Expand]Data 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]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap 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]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

How would you rate this topic?​​​​​​​