Analysis Services Tutorial

Question

so I downloaded the AdventureWorksDB  from

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

this package because I have a x64 server? AdventureWorksDB_x64.msi

I can install and attach it just fine but the Tutorial does not match up at all?  So far.

http://msdn.microsoft.com/en-us/library/ms170402(SQL.90).aspx

when Defining a Data Source View instructs to select these tables

dbo.DimCustomer

dbo.DimGeography

dbo.DimProduct

dbo.DimTime

dbo.FactInternetSales

these table do not exist in the sample database?

What gives; what adventure works db do I need to get to be able to follow the tutorials?

 

Answer 1

Please get the SQL Server 2005 sample all-in-one package from http://sqlserversamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=4000&DownloadId=11735. That one should work well with the SQL Server 2005 Tutorial you found.

You probably have downloaded a newer version of AdventureWorks database, in which the schema has changed(to accommodate some new samples in SQL Server 2008 or later.)

Answer 2

The database should install for this tutorial is AdventureWorksBI.msi or the x64 version one in http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004. BI means business intelligence(Analysis Service is part of BI). I think these two are same. Only the x64 setup is for x64(my guess). But it definitely has the tables like DimTime, DimProduct etc.