OLAP Mode Limitations
- 2 minutes to read
An OLAP data source has the following limitations:
-
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:
-
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:
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.