OLAP Mode Limitations

• Oct 12, 2023
• 2 minutes to read

An OLAP data source has the following limitations:

• Dashboard Parameters

• Complex Filter Conditions

You cannot use the following features for an OLAP data source:

• Calculated Fields
• Window Calculations
• Data Source Filtering
• Custom Grouping
• Summary Type Changing
• Continuous Chart Argument Axis
• Top N - Show ‘Others’ value
• Visible Data Filter

Supported OLAP Servers

The following OLAP servers are supported:

• Microsoft SQL Server 2000 Analysis Services (requires SP4)
• Microsoft SQL Server 2005 Analysis Services (requires Microsoft SQL Server 2005 Service Pack 2)
• Microsoft SQL Server 2008 Analysis Services (requires Microsoft SQL Server 2008 Service Pack 1)
• 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

In MS SQL Server Analysis Services 2000, the Dashboard control does not support a cube’s dimension members with DBNull values.