In Strategy 9.3.1 and 9.4.0 Readme files, the support status of SQL Server 2012 Analysis Services in Tabular Mode is listed as follows:
Strategy 9.3.1:
https://resource.microstrategy.com/support/releasenote/9.3.1/ReleaseNotes/ReadMe_Server_5.htm#XDA
The 'Status' column listed as abaove is incorrect. For both release, this column should read:
“Supported with use of InMemory query mode.”
This is due to the fact that the Strategy Engine can only generate MDX and not DAX which is required for use with DirectQuery.
The screenshots below illustrate what to look for when designing a new Tabular project in 2012 and also when working with an existing Tabular database on 2012.
New project and Query Mode option set to “In-Memory”
Existing Tabular database showing the supported DirectQueryMode of “InMemory”:
The Strategy Internal Reference number for the issue described in this technical note is 805077.
