ITEM
1. ITEM (Return type: MEMBER)
Description:
This function is used to return a member from a specified tuple.
Syntax:
Tuple_Expression.Item( Index )
Return Type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Tuple_Expression | It is a valid MDX expression that returns a set. |
Index | A valid numeric expression that specifies the specific member by position within the tuple to be returned. |
Example:
SELECT
[Measures].[Internet Sales Amount] on 0,
{( [Customer].[Geography].[Country].&[Australia], [Measures].[Internet Freight Cost] ).Item(0)} ON 1
FROM [AdventureWorksMF] 2. ITEM (Return type: TUPLE)
Description:
This function is used to return a tuple from a set.
Syntax:
Set_Expression.Item(Index)
Return Type:
TUPLE
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Index | It is a valid numeric expression that specifies the specific tuple by position within the set to be returned. |
Example:
SELECT {[Measures].[Customer Count]} ON 0,
{ Descendants
( [Customer].[Geography].[Country].&[Australia],
[Customer].[Geography].[State-Province],SELF
).Item(0)
} ON 1
FROM [AdventureWorksMF]