OLAP Mode Limitations

• Mar 10, 2021

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