SUBSET
Description:
This function is used to return a subset of tuples from a specified set.
Syntax:
Subset(Set_Expression, Start [ ,Count ] )
Return type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Start | It is a valid numeric expression that specifies the position of the first tuple to be returned. |
Count | It is a valid numeric expression that specifies the number of tuples to be returned. |
Example:
WITH MEMBER [Measures].[Page 2 Sales] AS
SUM(Subset([Product].[Product].[Product].Members, 10, 10), [Measures].[Internet Sales Amount])
SELECT [Measures].[Page 2 Sales] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]