OLAP Mode Limitations

• Oct 12, 2023
• 2 minutes to read

An OLAP data source has the following limitations:

• Dashboard Parameters

  Dashboard Parameters can be used with the OLAP data source in code. For instance, the following example shows how to filter data by a dynamic dashboard parameter that uses an OLAP data source:

  View Example: How to: Filter Dashboard Item's Data in OLAP Mode

• Complex Filter Conditions

  In OLAP mode, the filter expression can contain only specific logical operators and operands:

  • Attributes in the hierarchy can be filtered only with “and” and “or” criteria operators.
  • Separate dimension attributes and hierarchies can be filtered only with “and” criteria operators.

  For instance, the following example shows how to apply a filter to a dashboard item’s data in OLAP mode:

  View Example: How to: Filter Dashboard Item's Data in OLAP Mode

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.