Exists (MDX)

Returns the first set filtered by an existing rule based on the second set.

Parameters

Name	Type	Cardinality	Default value
	set-expression	one
	set-expression	zero-one

Return

set

Description

Returns a set of existing tuples.

A single set as parameter :

This function filters out tuples that do not exists. A tuple does not exist if it contains members of the same dimension but different hierarchies whose combination is always empty by construction. For example the [Geography] dimension defines two hierarchies: [Geo] and [Economy]. The both have a level country; by construction the tuple ([Geo].[United States], [Economy].[Spain]) is not possible.

Two sets as parameter :

This function returns the tuples in the first set that are non empty when evaluated across the tuples of the second set.

Note, this function is faster than his equivalent NonEmpty() as it can be solved without querying the fact tables.

Examples

Exists(tuple_set)

Returns all set members that exists, hierarchy wise, from the tuple set.

In our example, [Geo].[France] and [Economy].[Canada] does not exist (by dimension construction)

Query

WITH
    MEMBER ExistingCountries as count ( exists( {([Geography].[Geo].[All Regions].[Europe].[France],[Geography].[Economy].[Country].[Canada])}) )
SELECT
    ExistingCountries on 0
FROM
    [Sales]

Result

ExistingCountries
0

ExistingCountries

Assertion : Cell Equals

WITH
    MEMBER ExistingCountries as count ( { ( [Geography].[Geo].[All Regions].[Europe].[France], [Geography].[Economy].[Country].[Canada] ) } )
SELECT
    ExistingCountries on 0
FROM
    [Sales]

Assertion : Cell Equals

WITH
    MEMBER ExistingCountries as 0
SELECT
    ExistingCountries on 0
FROM
    [Sales]

Exists(tuple_set,tuple_set)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.