Item

Return to: Calculated Member Builder Function List

Returns a member from a tuple or a tuple from a set.

  Members Tuples
Syntax «Tuple».Item(«Numeric Expression») «Set».Item(«String Expression»[, «String Expression»...] | «Index»)
Remarks Returns the member whose zero-based position in the tuple is specified by «Numeric Expression». Returns a tuple from «Set». The «String Expression»[, «String Expression»...] specifies which tuple to retrieve. The «Index» value specifies the position of the tuple in «Set». The numbering of the tuples is zero-based.
Example Time.Year.Members.Item(0)
returns [1996]
{([1994],Sales), ([1995],Sales), ([1996],Sales)}.Item(0) returns ([1994],Sales).

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.