Export (0) Print
Expand All

Item

SQL Server 2000

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)
Show:
© 2014 Microsoft