How to determine what version of the SSAS Client is being used


Technique

Product: Reporting Server
Release: 8205
Primary OS: Windows
Solution Date:

Problem

How to determine what version of the SQL Server Analysis Services (SSAS) Client is being used.

Solution

To determine the version of the SQL Server Analysis Services Client in use, create a procedure on the Reporting Server containing the following: 



ENGINE SSAS SELECT * FROM NOSUCHTABLE;

END



If the client is an older version, the resulting error will include the provider version. Since the newer versions of the client does not return the version, the following can be performed instead:



SET TRACEOFF=ALL

SET TRACEON=MDXDI/1/CLIENT

SET TRACEUSER=ON



SQL SSAS SELECT * FROM NOSUCHTABLE;

END



Look for the Provider Version in the trace.