Prerequisites; -
All the prerequisites are downloadable from the following location; -

The prerequisites are; -
AdventureWorks2012 Data File
AdventureWorksDW2012 Data File
AdventureWorks Multidimensional Models SQL Server 2012

Attach the AdventureWorks2012 and AdventureWorksDW2012 databases to a Database Engine instance; -

Deploy the SSAS solution 'AdventureWorks Multidimensional Models SQL Server 2012' to an Analysis Services instance within SSDT

N.B; - Not all of the samples require 'AdventureWorks Multidimensional Models SQL Server 2012'

Download the zip file from the Downloads tab pane to your desktop.
Unzip this zip to reveal your SSRS solution.
Change the data source "AdventureWorks" to point to your AdventureWorks2012 database.
Change the data source "AdventureWorksAS" to point to your 'AdventureWorks Multidimensional cube.

Any further questions, please ask.

There is a high quality WIKI on AdventureWorks2012 in the following link; -

Last edited May 25, 2013 at 1:15 PM by KieranWood, version 4


Ruimin678 Mar 21 at 4:04 PM 
Hi, KieranWood,

I downloaded and open the solution. Nothing seems to be missing anymore.


Ruimin678 Mar 21 at 3:56 PM 
Hi KieranWood,

The AdventureWorks Sample Reports 2012 solution seems to be missing Employee Sales Summary.rdl. Where can I get it?