Not (PQL)

Returns a list of elements from a hierarchy EXCEPT the ones supplied in the specified list

  • Returned Output: List
  • Library: PQL \ Semantic \ List
  • Version: 2018.00.000
  • Compatibility: Pyramid Query Language (PQL) data sources

Syntax

Not( <List> )

* Click on the function's arguments above for more details on the input values.

Comments
  • List represents a list of elements to exclude from the result of elements derived from the entire hierarchy.
  • For details on how to employ and use this function see the semantic calculation overview.

This function is similar to the MDX except function; it retrieves the members of a hierarchy by excluding the elements from the specified list.

The Not function is useful for building sets or lists by excluding members from other lists. It is related to the Except method.

Examples

This example retrieves all the countries from the customer dimension (or table) EXCEPT for Australia, United States, and Canada:

Not( {[Customer].[Country].[Australia], [Customer].[Country].[United States], [Customer].[Country].[Canada]} )