SSAS DB not visible in Management Studio but can be seen in Excel
sql-server, ssas, ssms
Solution
SSMS is a administration tool. You will only see databases in there to which you have admin access. So if you are not a server admin or are not in a role in any of the databases which has admin rights - you will not see any databases in the object explorer.
Problem
There is a SQL 2012 Analysis Server with some cubes. When I connect to it using Excel 2013 (DATA menu > From Other Sources > From Analysis Services), I can see the DB names in the dropdown. But when I connect to it with SQL Server Management Studio 2012 (with Analysis Service Client installed, I've used it against other Analysis Servers successfully), I can connect to the Analysis Server, but cannot see any DB - the Databases folder is empty. Did I miss anything? Is it possible that it's intentionally configured to be so?