How to find list of databases on Microsoft Analysis Server(SSAS)

Question

I want to know if I can find out list of analysis databases on an Analysis Server by simply writing a query. I am working on SQL Server 2008.

Answer 1

I am sharing this information by answering my own question here cause this I found out at a blog post and this I think is very useful for a BI developer. Following is the MDX query to get the list of SSAS databases on that server.

SELECT [catalog_name] as [Database Name] FROM $SYSTEM.DBSCHEMA_CATALOGS.