AdventureWorksDW2008R2 Cube

Question

Downloaded and attached AdventureWorksDW2008R2_Data.mdf file to SQL Server.  When go into Microsoft SQL Server Management and connect to Analysis Server, I do not see any database or cubes listed.  Database does shows under Database connection.  Question is what I have to do to get the cube for the DW to show.

Answer 1

Hi PhilTX,

It appears that the SSAS sample project that used to be at http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database has been deleted.  I have raised this issue with Microsoft to see where it's gone and whether it can be uploaded again.

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 2

The following link contains SSAS tutorials which take you through the steps of creating the cube from scratch

http://sqlserversamples.codeplex.com/releases/view/72278

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 3

Hi PhilTX,

You can find the AdventureWorks 2008 Analysis Services sample project source files at http://msftdbprodsamples.codeplex.com/releases/view/88252. The download contains source files to build and deploy the AdventureWorks OLAP Cubes.

We value your feedback on the process of creating SQL Server samples that reflect your needs.

When you see answers and helpful posts, please click Vote As Helpful,Propose As Answer, and/or Mark As Answer

Answer 4

Thanks Derrick and Mr. Wharty.  I will wait until corrected code is posted.  I also was receiving deployment errors for Processing Partition '~CaseDetail ~MG' and Processing Partition 'Internet ~1 ~MG'.

Answer 5

We uploaded AdventureWorks 2008R2 Analysis Services Project.zip to http://msftdbprodsamples.codeplex.com/releases/view/88252. Please note that we tested the project on SQL Server 2008R2.

Answer 6

I downloaded the ZIP file and successfully deployed.  Thanks for the great support.