Skip to main content

OLAP Requirements and Limitations

  • 2 minutes to read

OLAP mode requirements are listed in the following table:

Provider

Side

Requirements

ADO MD Provider

Server side

No specific requirements for the supported Microsoft SQL Server Analysis Services installations

Client side

The 10.0 (MSOLAP) OLE DB Provider is required.

OLE DB Provider

Server side

When using MS SQL Server Analysis Services 2005 Analysis Services, MS SQL Server 2005 Service Pack 1 is required. We suggest that you install SP3 to avoid bugs in SQL Server 2005.

When using MS SQL Server Analysis Services 2000 Analysis Services, SP4 is required.

Client side

The ExpressPivotGrid control requires the Analysis Services 8.0, 9.0 (MSOLAP), or 10.0 (MSOLAP) OLE DB Provider to be installed.

To download any of the Analysis Services OLE DB Providers for the client side, visit https://www.microsoft.com/en-us/ and search for the “Feature Pack for SQL Server” string. The result should contain links to pages describing the most recent versions of feature packs. Open the required page and locate the link to the Analysis Services OLE DB Provider.

The following pivot grid features are not supported in OLAP mode:

Limitations of fields bound to OLAP cube elements are listed below:

  • A field representing a cube measure or KPI can be positioned only within the data header area. This field corresponds to a data field.

  • A field representing a cube dimension or named set cannot be positioned within the data header area. This field corresponds to a column, row, or filter field.

  • An unbound field (with unassigned or incorrect UniqueName property) cannot be displayed within the pivot grid.

  • Two or more fields bound to the same cube element are not supported.

  • Field value formats cannot be customized via a field’s DisplayFormat property, because the resulting display values are retrieved as is from bound OLAP cubes. Instead, you can assign a formatting editor for a field to format its values and specify formatting patterns via the editor’s options.