Distinct
The MDX Distinct function for Essbase deletes duplicate tuples from a set.
Syntax
Distinct ( set )
Parameters
- set
-
The set from which to remove duplicates.
Notes
-
Duplicates are eliminated from the tail of the set.
-
Distinct of an empty set returns an empty set.
Example
The expression
Distinct({[Colas], [Root Beer], [Cream Soda], [Colas]})
returns the set
{[Colas], [Root Beer], [Cream Soda]}
Note that the duplicate [Colas] is removed from the end of the set.