Report Portal

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

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.