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.