EXISTS
Description:
This function is used to return the set of tuples from the first set specified that exist with one or more tuples from the second set specified. The function performs manually what auto performs automatically.
Syntax:
Exists( Set_Expression1 , Set_Expression2 [, MeasureGroupName] )
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression1 | It is a valid MDX expression that returns a set. |
Set_Expression2 | It is a valid MDX expression that returns a set. |
MeasureGroupName | It is a valid string expression specifying a measure group name. |
Example:
SELECT [Measures].[Customer Count] ON 0,
EXISTS(
[Customer].[Geography].[State-Province].MEMBERS
, {[Customer].[Geography].[State-Province].&[Australia]&[Queensland]}
) ON 1
FROM [AdventureWorksMF]