MDX-How do you extract first member from the tuple?
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