Get Results from DMV Query into SQL Server Table
In SSAS, there's no such thing as a table; it's all multi-dimensional stuff. What you need to do is get the results into a table in a database engine instance.

Here's one way to do it:


Create a linked server to SSAS on your management SQL Server database engine instance. (Note: you'll need to install the SSAS drivers if the two instances aren't on the same box.)
Create a job in SQL Agent that periodically queries the SSAS DMV over the linked server and dumps the results into a relational table.