SQL Server Analysis Services Tutorial (Where are the sample databases)

Question

After trying to resolve an error in deploying the cube for the SQL server Analysis tutorial lesson 2. I decided to go to lesson 3 and open the sample database to get the deployed cube. Lesson 3 that starts on this page

http://technet.microsoft.com/en-us/library/ms166587.aspx

Is telling me to go to codeplex to get the sample database for lesson 2 from this place

 

Note
A completed project through Lesson 2 is available by downloading and installing the samples. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

 

The link goes to http://technet.microsoft.com/en-us/library/ms161556.aspx

There is no such database (the database for the tutorial). Anyone going through this tutorial is looking for  a  link to download a file. Not a link to a download area that doesn't tell them where to get the specific sample they are looking for.

Can you tell me where to get the sample database for Tutorial Lesson 3? Where are the .dwproj and the .asproj or the .sln files for the tutorials?

 

Answer 1

Hi,

Yes, those links do go around in circles and get you no where. 

You can download the files for the Analysis Services tutorial from here: http://msftdbprodsamples.codeplex.com/releases/view/4004.  Run the AdventureWorksBI.msi from that page.  Or, if you have an X64 or IA64 server, choose the corresponding AdventureWorksBI msi from the list.

The installation package will copy the files to C:\Program Files\Microsoft SQL Server\90\Tools\Samples  be default unless you choose a different location during installation.

Kind regards,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Hi,

Is this the link for the Lesson 1 through 10 tutorials?

Thanks.

Martine

Answer 3

Yes. It is the link, to the analysis services sample database project files.  AFAIK, the entire tutorial is based on those files.

 

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

You need to go to: "C:\Program Files\Microsoft SQL Server\90\Tools\Samples" and there you will find the msi file "SQLServerSamples.msi" -run it . It will install the sample files you need.

Answer 5

Hi,

Yes, those links do go around in circles and get you no where. 

You can download the files for the Analysis Services tutorial from here: http://msftdbprodsamples.codeplex.com/releases/view/4004.  Run the AdventureWorksBI.msi from that page.  Or, if you have an X64 or IA64 server, choose the corresponding AdventureWorksBI msi from the list.

The installation package will copy the files to C:\Program Files\Microsoft SQL Server\90\Tools\Samples  be default unless you choose a different location during installation.

Kind regards,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Hi, I'm an SSAS noob trying to work my way through a book, ad in the lesson about deploying a sample cube, it says to open "Adventure Works DW 2008.dwproj" in the folder "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\standard", but my problem is that once I get to the Samples folder, it's empty except for an htm file linking me to the codeplex website.

Would running AdventureWorksBI.msi work in this situation?  I noticed that your answer said it would copy files into the \90 folder instead of \100, but could I still use it?

Answer 6

The above link is for SQL Server 2005.  You can download 2008 samples databases here http://msftdbprodsamples.codeplex.com/releases/view/59211

---

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 7

Thanks for the reply, Mr. Wharty - I've already downloaded and installed the sample database for 2008R2 (which was tricky for a beginner like me, especially since there was no log file), but there are no sample cubes in the download.  Do you know where I can find them?

Answer 8

My apologies. 

The following link contains the DB and Projects for 2008 which I believe work with 2008R2 as well.

AdventureWorks2008_SR4.exe: http://msftdbprodsamples.codeplex.com/releases/view/37109#DownloadId=96448

---

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 9

@tengen1010: You can find the AdventureWorks 2008 Analysis Services sample project source files at http://msftdbprodsamples.codeplex.com/releases/view/88252.

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

Answer 10

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.