2

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.

5

The easiest way is :

using SSMS -- connect to instance --> reports -> standard reports --> General

enter image description here

enter image description here

There are other ways as well - How to find Analysis Services Server Version ?.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.