Skip to content

Instantly share code, notes, and snippets.

@matt40k
Created May 18, 2016 09:59
Show Gist options
  • Save matt40k/0b7f03dde32f28f620a8dfa5392648f1 to your computer and use it in GitHub Desktop.
Save matt40k/0b7f03dde32f28f620a8dfa5392648f1 to your computer and use it in GitHub Desktop.
Get cube names from SSAS
SELECT
[CUBE_NAME]
FROM
$SYSTEM.MDSCHEMA_CUBES
WHERE
CUBE_SOURCE=1
AND [BASE_CUBE_NAME] < ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment