Skip to content

Instantly share code, notes, and snippets.

@harsha547

harsha547/MDX_Query_5.SQL

Created March 25, 2017 20:47
Show Gist options
  • Save harsha547/03a2f5b47cc1dfaaa6d1cbd5ff741daa to your computer and use it in GitHub Desktop.
Save harsha547/03a2f5b47cc1dfaaa6d1cbd5ff741daa to your computer and use it in GitHub Desktop.
Download ZIP
MDX Query ( Database : Adventureworks )
Raw
MDX_Query_5.SQL
-- 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]
@harsha547
Copy link
Author

Solution 👍
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment