OLAP Mode Limitations

• Oct 08, 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:

• 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 filtering to a dashboard item’s data in OLAP mode:

The features listed below are not supported 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.