Analysis Services
Extract
Returns a set of tuples from extracted dimension elements.
Syntax
Extract(«Set», «Dimension»[, «Dimension»...])
Remarks
This function returns a set consisting of tuples from the extracted «Dimension» elements. This function always removes the duplicates. The Extract function performs the opposite action of the Crossjoin function.
Example
This example
Extract({([1997], Washington), ([1997], California), ([1998], California)}, Time)
returns the set
{[1997], [1998]}