Wednesday, 16 May 2012

How do you extract first tuple from the set? | MS-BI

Use could usefunction Set.Item(0)
Example:
SELECT {{[Date].[Calendar].[Calendar Year].Members
}.Item(0)}
ON 0
FROM [Adventure Works]

No comments: