Thursday, March 26, 2015

How do you extract first tuple from the set?

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

No comments:

Post a Comment