List of Not Supported Expressions

Aggregation filters can be applied to measures based on standard aggregations such as SUM() or COUNT(). However, measures that use specific window or advanced expressions cannot be used with aggregation filters. If an aggregation filter refers to such a measure, the query will fail with the following error message.

General error (ERROR: window functions are not allowed in HAVING Position:)

The following expression types are not supported in measures that are referenced by an aggregation filter.

PERCENT_RANK
CUME_DIST
PERCENTILE
NORMALIZE
ROW_ID

Any other Datamart Expressions implemented on top of these window functions are also not supported.

Examples

Supported Expressions

The following examples can be safely used in an aggregation filter.

SUM(ListPrice)

COUNT(CustomerId)

Not Supported Expressions

The following examples cannot be safely used in an aggregation filter.

PERCENT_RANK(SUM(ListPrice)

NORMALIZE(COUNT(CustomerId))