Returns one member from set with specified position (starting from zero) or name.
Syntax
Code Block |
---|
Index syntax
Set_Expression.Item(index)
String expression syntax
Set_Expression.Item(String_Expression1 [ ,String_Expression2,...n]) |
Arguments
Set_Expression | MDX expression that returns set. |
---|
index | Numeric expression that specifies the position of tuple in the set. |
---|
String_Expression | String expression that is a typically a tuple expressed in a string. |
---|
Examples
In the following example item function can be used to return the first element in a sorted member list to get the last invoice date for the current customer.
order
[Invoice].[Invoice].members, |
[Invoice].CurrentMember.getString('Customer code') = [Customer].CurrentMember.getString('KEY') |
[Invoice].CurrentMember.get('Invoice date'), |
).Item(0).get('Invoice date') |
See also