Cacher is the code snippet organizer for pro developers

-- To list all the countries from specified dimenison

-- Here we are retrieving all the members of the country 

SELECT
  { } on 0,
  { DESCENDANTS([Geography].[Country]) } on 1
FROM [Adventure Works]