Returns a set of tuples with members from the specified dimensions of the input set.
Extract ( set [, dimension ... ] )
set | The set from which to extract tuples belonging to the specified dimension. |
dimension | One or more dimensions from which to extract a set. |
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.
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 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |