In SQL Server on the database engine, you can run a SQL query like this to get the server's version info like Edition and Version, and Update Level, etc.
SELECT @@VERSION
What is the MDX equivalent for querying an SSAS (Tabular or Multidimensional) instance? Are there SSAS DMVs that can get me this answer?
I browsed the Books Online page for SSAS DMVs, but I didn't notice any DMVs that could help me. DISCOVER_INSTANCES didn't seem to have the info.
Let's assume that SQL Server Database Engine is not installed on this same server as the SSAS instance, so I cannot check this by querying the database engine.
In my case, this is for a SQL 2012 Tabular instance, but would like to know how to query Multidimensional instance too.
Best Answer
The easiest way is :
using SSMS -- connect to instance --> reports -> standard reports --> General
There are other ways as well - How to find Analysis Services Server Version ?.