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


Leave a Reply

Your email address will not be published. Required fields are marked *

Name *
Email *
Website