Extract
The MDX Extract function for Essbase returns a set of tuples with members from the specified dimensions of the input set.
Syntax
Extract ( set [, dimension ... ] )
Parameters
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
Table 4-63 Output Grid from MDX Example
Qtr1 | Qtr2 |
---|---|
24703 | 27107 |