GETFILTERINFO
Description:
This function is used to return the set of tuples on a specified axis of the sub-select.
Syntax:
GetFilterInfo(Hierarchy_Expression)
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Example:
WITH MEMBER [Measures].[Date Filter] AS
GetFilterInfo([Date])
SELECT
[Measures].[Date Filter] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]
WHERE [Date].[Calendar].[Calendar Year].[2012]