OLAP Mode Constraints

An OLAP data source in Compyl has certain limitations that users should be aware of. These limitations affect the way OLAP data can be used and manipulated within the dashboard.

Supported Features

The following are features supported in OLAP Mode:

1. Dashboard Parameters

Dashboard Parameters can be used with the OLAP data source in code. For example, you can filter data by a dynamic dashboard parameter that utilizes an OLAP data source.

2. Complex Filter Conditions

In OLAP mode, filter expressions are restricted to specific logical operators and operands:

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

Unsupported Features

The following features are not supported when using 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

Compyl supports the following OLAP servers:

• 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 Compyl dashboard does not support a cube’s dimension members with DBNull values.

Understanding these limitations helps ensure that you can effectively plan and utilize OLAP data sources within Compyl. For more detailed information and assistance, refer to the Help Center or contact Compyl customer support.