How do I tell which Edition and Version my SSAS Instance is running?
2
votes
2
answers
8183
views
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.
Asked by John G Hohengarten
(674 rep)
May 2, 2016, 04:30 PM
Last activity: Feb 24, 2023, 03:12 PM
Last activity: Feb 24, 2023, 03:12 PM