where is AdventureWorks 2008R2 SR1 download? (analysis services sample project)

Question

the page on codeplex (http://msftdbprodsamples.codeplex.com/releases/view/55926)

has no files under downloads

Available Downloads

There are no downloads associated with this release.

Release Notes

I've attached the AdventureWorks2008R2_Data & AdventureWorksDW2008R2_Data mdfs

ive run the closest thing i could find to the 2008r2 samples installer (SQL2008.All_Product_Samples_Without_DBs.x64.msi) and that installed fine, but there's no C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\ folder

it did create C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Tutorials\ but when i tried to deploy lesson 10 complete I got the following error

MdxScript(Analysis Services Tutorial) (77, 40) The '&[2005]' member was not found in the cube when the string, [Date].[Fiscal Date].[Fiscal Year].&[2005], was parsed.

Answer 1

Hello,

Use this one http://msftdbprodsamples.codeplex.com/releases/view/59211 as mentioned in the description of 2008R2 SR1.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

hi olaf thanks for the link but as mentioned in my post i already have the data files. im looking for the sample files msi installer

Answer 3

The installer includes all, the database and the samples.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

Hi Olaf,

Which of these downloads at the link you provided is the installer?

Recommended Download

AdventureWorks2008R2 Data File

application, 200640K, uploaded Apr 3 - 73683 downloads

Other Available Downloads

AdventureWorksDW2008R2 Data File

source code, 74944K, uploaded Apr 3 - 5082 downloads

AdventureWorks 2008R2 OLTP Script

application, 20074K, uploaded Apr 2 - 4092 downloads

AdventureWorks 2008R2 DW Script

source code, 9018K, uploaded Apr 3 - 3569 downloads

All I see is MDFs and a zip with CSVs and a .sql script

Thanks

Answer 5

Switch from tab "Download" to "Source Code", at the right site under "Latest Version" there is a "Download" link; here you can get the complete source of the project (~880 MB).

It's a ZIP file you can extract to any location you like, in it you will find also the BIDS procject for the SSAS database / cube.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 6

Thanks,

I'll do that when I get home from work

But what you're saying is that there's no individual installer for the sample project files anywhere on codeplex for sql server 2008 r2??