RANGE

Description:

This function is used to return the set that is a subset of parameter set, starting at the first member's parameter till the second one.

Syntax:

Range(Member_Expression1, Member_Expression2)

Return type:

SET

Parameters:

Parameter	Description

Parameter	Description
Member_Expression1	It is a valid MDX expression that returns a member.
Member_Expression2	It is a valid MDX expression that returns a member.

Example:

WITH MEMBER [Measures].[First Half Sales] AS
    SUM([Date].[Calendar].[Month].[January 2012] : [Date].[Calendar].[Month].[June 2012],
        [Measures].[Internet Sales Amount])
SELECT [Measures].[First Half Sales] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]