Analysis Services
Item
Returns a member from a specified tuple. Alternatively, returns a tuple from a set.
Syntax
Member
«Tuple».Item(«Index»)
Returns a member from the tuple specified in «Tuple». The member to be returned is specified by the zero-based position of the member in the tuple in «Index».
Tuple
«Set».Item(«String Expression»[, «String Expression»...] | «Index»)
Returns a tuple from the set specified in «Set». The tuple to be returned is specified either by name in «String Expression», or by the zero-based position of the tuple in the set in «Index».
Examples
Member
The following example returns [1999]:
([1999],Sales, [2000],Sales).Item(0)
The following example returns [1996], if [1996] is the first member in the Year level of the Time dimension:
Time.Year.Members.Item(0)
Tuple
The following example returns ([1996],Sales):
{([1996],Sales), ([1997],Sales), ([1998],Sales)}.Item(0)