EXISTS
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
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].[Internet Sales Amount] ON COLUMNS, Exists([Product].[Product].[Product].Members, {[Customer].[Geography].[Country].&[United States]}) ON ROWS FROM [AdventureWorksMF_ValueBased]