Returns a set of tuples with members from the specified dimensions of the input set.
Syntax
Extract ( set [, dimension ... ] )
Parameter | Description |
---|---|
The set from which to extract tuples belonging to the specified dimension. | |
One or more dimensions from which to extract a set. |
Notes
This function always removes duplicates. The dimension argument should specify dimensions present in the input set. It is an error to specify a dimension that is not present in the input set. The members in the tuples of the output set are ordered based on the dimension order specified in the input set.
Example
In the following example, Extract returns a subset of only those tuples belonging to the Year dimension.
SELECT Extract( { ([Year].[Qtr1], [Market].[California]), ([Year].[Qtr1], [Market].[Oregon]), ([Year].[Qtr2], [Market].[Oregon]) }, Year ) ON COLUMNS FROM Sample.basic
Qtr1 | Qtr2 |
---|---|
24703 | 27107 |