SSAS FAQ MDX FAQ MDX-How do you extract first member from the tuple?
MDX-How do you extract first member from the tuple?
User Rating: / 0
PoorBest 
Written by Vidas Matelis   
Tuesday, 27 March 2007 09:29

Q: How do you extract first member of the tuple?

A: Use function Tuple.Item(0)

MDX Query example:

SELECT {([Date].[Calendar].[Calendar Year].&[2003]
, [Customer].[Customer Geography].[Country].&[Canada]).Item(0)
}
ON 0
FROM [Adventure Works]

Result:

CY 2003
$32,202,669.43

Different query:

SELECT {([Date].[Calendar].[Calendar Year].&[2003]
, [Customer].[Customer Geography].[Country].&[Canada]).Item(1)
}
ON 0
FROM [Adventure Works]

Result is different:

Canada
$80,450,596.98

< Prev
 
Strategy Companion