• Article

Exists (MDX)

Returns the set of tuples of the first set specified that exist with one or more tuples of the second set specified. This function performs manually what auto exists performs automatically. For more information about auto exists, see Key Concepts in MDX (MDX).

If the optional <Measure Group Name> is provided, the function returns tuples that exist with one or more tuples from the second set and those tuples that have associated rows in the fact table of the specified measure group.

Syntax

Exists( Set_Expression1 , Set_Expression2 [, MeasureGroupName] )

Arguments

  • Set_Expression1
    A valid Multidimensional Expressions (MDX) expression that returns a set.

  • Set_Expression2
    A valid Multidimensional Expressions (MDX) expression that returns a set.

  • MeasureGroupName
    A valid string expression specifying a measure group name.

Remarks

Measure group rows with measures containing null values contribute to Exists when the MeasureGroupName argument is specified.

Examples

Customers who live in California:

SELECT [Measures].[Internet Sales Amount] ON 0,
EXISTS(
[Customer].[Customer].[Customer].MEMBERS
, {[Customer].[State-Province].&[CA]&[US]}
) ON 1 
FROM [Adventure Works]

Customers who live in California with sales:

SELECT [Measures].[Internet Sales Amount] ON 0,
EXISTS(
[Customer].[Customer].[Customer].MEMBERS
, {[Customer].[State-Province].&[CA]&[US]}
, "Internet Sales") ON 1 
FROM [Adventure Works]

Customers with sales:

SELECT [Measures].[Internet Sales Amount] ON 0,
EXISTS(
[Customer].[Customer].[Customer].MEMBERS
, , "Internet Sales") ON 1 
FROM [Adventure Works]

Customers whom bought Bikes:

SELECT [Measures].[Internet Sales Amount] ON 0,
EXISTS(
[Customer].[Customer].[Customer].MEMBERS
, {[Product].[Product Categories].[Category].&[1]}
, "Internet Sales") ON 1 
FROM [Adventure Works]