RANGE
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
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 |
|---|---|
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]