|
I initially compiled this table in a Power Point slide deck when I was studying for my MCSE BI, so most likely the original source is from a Microsoft textbook, but you can also easily find this same information on TechNet. (https://technet.microsoft.com/en-us/library/ms174532(v=sql.110).aspx). I am posting this table for you because I often just want the abbreviated version and I appreciate the table view.  A few more notes on "cached" vs "DirectQuery", and DirectQuery Properties.  
0 Comments
 You can read up on how to do this on MSDN here (https://msdn.microsoft.com/en-us/library/gg471594.aspx), but below is a quick summary. The easiest option is to connect to SQL Server Management Studio and note the icon next to the server name in Object Explorer. An alternative is the read the XML in the MSMDSRV.INI file searching for “DeploymentMode”. 0 = multidimensional 1 = PowerPivot for SharePoint 2 = Tabular  |
| Microsoft Data & AI | SQL Server Analysis Services |
RSS Feed