OLAP Requirements and Limitations
- 3 minutes to read
OLAP mode requirements are listed in the following table:
Provider | Side | Requirements |
|---|---|---|
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. | |
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. You can find a list of the bugs that have been fixed in SQL Server 2005 Service Pack 3 at https://support.microsoft.com/en-us/topic/kb955706-list-of-the-bugs-that-are-fixed-in-sql-server-2005-service-pack-3-25ea645a-cb1c-cb57-7a23-99b3c3c2cc1d. 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.
To learn about the latest versions of providers and their specifics, refer to the “How to obtain the latest versions of MSOLAP” online article at https://support.microsoft.com/en-us/topic/how-to-obtain-the-latest-versions-of-msolap-7e83308f-535d-2919-bc4a-20d402f87722.
The following pivot grid features are not supported in OLAP mode:
The Sorting by Summary feature.
The Top N Values feature.
The ADO MD Provider doesn’t support KPIs, the TcxPivotGridDrillDownDataSet component, and a cross cell’s CreateDrillDownDataSource function.
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.