Skip to content

Instantly share code, notes, and snippets.

@Hugoberry
Created May 17, 2021 10:05
Show Gist options
  • Save Hugoberry/1b772e69900dc8d8d4e21b71391395ab to your computer and use it in GitHub Desktop.
Save Hugoberry/1b772e69900dc8d8d4e21b71391395ab to your computer and use it in GitHub Desktop.
XMLA script to surface all DAX function definitions for SSAS
<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
<Command>
<Statement>
SELECT [Function_name], [ParameterInfo], [Description], [Interface_name], [Library_name] FROM $SYSTEM.MDSCHEMA_FUNCTIONS WHERE [Origin]=3 OR [Origin]=4
</Statement>
</Command>
<Properties>
<PropertyList>
<Catalog>a637e190-ed9c-46eb-84d7-3dc22e31a2e1</Catalog>
</PropertyList>
</Properties>
</Execute>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment