- #HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP HOW TO#
- #HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP FULL#
- #HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP PROFESSIONAL#
- #HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP DOWNLOAD#
#HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP HOW TO#
To learn more about how to attach a database, please refer to this TechNet article, Attach a Database.
I don’t need to worry about backing up the log for this database, so I also made sure that the Recovery Model is set to Simple. This database and the data will be the source of both of my tubular and multidimensional model. 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).
#HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP DOWNLOAD#
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.
#HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP PROFESSIONAL#
#HOW TO INSTALL ADVENTUREWORKS DATABASE ON LAPTOP FULL#
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.