I’ve named the new database AdventureWorksDW2012EE for Enterprise Edition. ON (FILENAME = N’C:\Adventure Works for SQL Server 2012\AdventureWorksDW2012_Data.mdf’) You can use the following T-SQL command with the option of FOR ATTACH_REBUILD_LOG to attach the database to the SQL Server database instance. mdf file you have just downloaded does not have the matching log file. The Adventure Works DW 2012 is the relational star schema database the sample tabular model database uses. The most frequently used data sources are the common relational database systems, text files, and excel workbooks. To create a tabular model, we also need data source(s).
If you are still running Excel 2010 like me, follow this link to download the free Power Pivot add-in.Ī typical multidimensional model is built on top of a relational star schema data warehouse. If you have Excel 2013, you are all set because PowerPivot is included by default. You can run PowerPivot in either Excel 2010 or Excel 2013. PowerPivot is the desktop tool for analyst for creating the tubular model, which is eventually consumed by Pivot Table for reporting. While you are at the installation, also make sure that you have PowerPivot. (Disclaimer: do not use this type of architecture on your production server.) Also need PowerPivot To make things easy for myself, I always add my own user ID as the administrator for each instance. The database engine is the default instance, and both the multidimensional model and the tabular model are named instances. To keep things simple, I have installed all three instances on my laptop.
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.