SQL Server 2012 Management Studio (desktop tool): older version of SSMS does not support Analysis Services tubular model.SQL Server 2012 Analysis Services – Tabular model (server instance).SQL Server 2012 Analysis Services – Multidimensional model (server instance): this is not required for learning DAX, but it can be extremely important to learn MDX and DAX side-by-side.SQL Server 2012 Database Engine (server instance): this is the relational database instance.I’ll assume that you have installed the following using the SQL Server Developer Edition or Enterprise Edition 2012: Assume you have installed SQL Server 2012 On Window 7 and 8, also make sure that unblock all the folders/files, and your user ID has full control on them. If you have seen the annoying “Path too long” error when you copy/past or unzip folders with very deep levels, you will appreciate my suggestion. I suggest that you unzip all the files onto a one level folder on your C drive, instead of the Windows built-in Downloads folder or the Documents folder. AdventureWorks Multidimensional Models SQL Server 2012.zip (also download this multidimensional sample project while you are there for leaning SSAS/MDX, if you haven’t done so.).AdventureWorks DW Tabular Model SQL Server 2012.zip.You can follow this link to CodePlex to download the following files: tinyurl/AdventureWorks2012. Download sample database and projects from CodePlex To learn the tubular mode/DAX, we also have a sample tabular project. We all know the famous Adventure Works multidimensional sample project.
0 kommentar(er)
