EXTRACT
Description:
This function is used to return a set of tuples from extracted hierarchy elements.
Syntax:
Extract(Set_Expression, Hierarchy_Expression1 [,Hierarchy_Expression2, ...n] )
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Hierarchy_Expression1 | It is a valid MDX expression that returns a hierarchy. |
Hierarchy_Expression2 | It is a valid MDX expression that returns a hierarchy. |
Example:
SELECT [Measures].[Average RateM] ON 0,
EXTRACT(
NONEMPTY(
[Date].[Calendar].[Date].MEMBERS,
{[Measures].[Average RateM]}
)
, [Customer].[Geography], [Date].[Calendar])
ON 1
FROM [AdventureWorksMF]