Wednesday, January 1, 2014

Install SSAS AdventureWorks 2012 Multi-Dimensional cube database (on Enterprise Edition)

If you want to install SSAS AdventureWorks 2012 Multi-Dimensional database and don't have enough information on how to proceed for the same then this post is designed for you.

1. Open CodePlex and download AdventureWorksDW2012 Data File (DirectLinkToDownload) mdf.



2. Open SQL Server 2012 Database Engine and you can create a relational database using downloaded mdf file. For step-by-step instructions and more details on How-to-attach, you can have a look at technet article.

3. After successful procedure from step2, check whether your relational database instance is showing you the appropriate database named "AdventureWorksDW2012" under database folder.

4. Go to the CodePlex site and download "AdventureWorks Multidimensional Models SQL Server 2012" (DirectlinktoDownload).



5. After successful download, you will get a zip file named "AdventureWorks Multidimensional Models SQL Server 2012", extract the file and go under "Enterprise" folder. Open Solution file.


6. Check the analysis server name under deployment properties and start deployment. After successful completion of deployment, you will be able to access your 2012 Multi-dimensional cube db.


7 comments:

  1. Thanks, this article made me realize that the adventure works cube database is linked to the DW database in the default database engine.

    Well done.

    ReplyDelete
  2. Can you explain in detail on "Check the analysis server name under deployment properties"

    I just opened the solution file, then built(succeed), then deployed. But I always failed at deploy. Error message is " "Errors related to feature availability and configuration. The "Perspectives" feature is not included in the "Standard" edition of Analysis Services."

    ReplyDelete
  3. Add additional info. The above post is for "Enterprise" solution.
    I can deploy the standard solution no problem.

    ReplyDelete