Using MDX to work with the File System
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL has functionality in it to work with the filesystem, send mail, handle message queuing, etc, ,but its usually a combination of technologies and these statements that is the best solution.
MDX is no exception. There are some interesting pieces of functionality that allow MDX to be used to work with the file system on your server. This is useful for things like backups, etc if you’re a SSAS Admin, but not an admin on the server.
Tags: management