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

sql-server-2008, ssas-2008

Solution

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.

Problem

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.

Original source