1. Download Adventureworks Database For Sql Server 2012 Express
2. Download Sql 2012 Adventureworks Database

Download Adventureworks Database For Sql Server 2012 Express

I want to install SSAS AdventureWorks 2012 Multi-Dimensional database.I have SQL Server Management Studio 2014 with an instance of the Database Engine installed and a 2014 instance of Analysis Services (Multidimensional).From codeplex I downloaded AdventureWorksDW2012 Multidimensional solution file and have opened and tried deploying with Visual Studio 2014 to Analysis Server Instance.Deployment fails.I can't find a link anywhere to help me with instructions for installing the Multi Dim database. Will someone tell me whether this should work in 2014 and share any ideas?

Download Sql 2012 Adventureworks Database

Polkadot (12/2/2015)Do I need the DW to be installed in order for the Multidimensional Analysis solution to deploy to Analysis services?Yes, because deploying from the Visual Studio solution means that the cube will have to be processed.and it needs the source database in order to accomplish that.If you only want the cube with all of it's data already included, see if you can get a backup of the SSAS database. I'm not sure if that is available on Codeplex as well. Note that you wouldn't be able to make any changes to the cube(s) without reprocessing it, so you may need the source database at some point and in any event. Then, since I'm using SQL Server 2014 and already have AdventureWorks2014 DW installed on the Database Engine, I've decided to download AdventureWorks 2014 Multidimensional Models from codeplex.Surprise though.When I extract the files, I find two folders: Enterprise and Standard (like before), and inside Enterprise is a file called AdventureWorksDW2014Multidimensional-EE.abf. Different!in multidimensionalmodels2012 the file extention for the cube was.sln and I could open it with Visual Studio. How do I open an.abf file and deploy THAT to Analysis Services????