Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Aleph_0
Yak Posting Veteran
79 Posts |
 Posted - 2011-09-29 : 20:15:01
|
| Hi there, SQL newbie and SSAS ignoramus here. I'm trying to learn SSAS but I'm having trouble getting started. I'm following the Microsoft SSAS Tutorial here:[url]http://msdn.microsoft.com/en-us/library/ms167105(v=sql.90).aspx[/url]It says to download AdventureWorksDW, but since I couldn't find it, I downloaded AdventureWorksDB (because it said the magical word, "recommended"). Then I installed the database using the instructions here:[url]http://msdn.microsoft.com/en-us/library/aa992075(v=VS.80).aspx[/url]Then I had a crunchy, juicy, Honeycrisp apple. When I'm trying to define a new data source, here's what I entered:Provider: Native OLE DB\SQL Native ClientServer name: (local)\sqlexpress (typing "localhost" didn't show any databases)Now when I look at the options for "Select or enter a database name", I see "AdventureWorks" (among others) instead of "AdventureWorksDW". Is that okay? Or will it cause depression, anal leakage, and erectile dysfunction?Thanks for putting up with my question! |
|
|
tduggan
Starting Member
26 Posts |
Posted - 2011-09-29 : 20:19:03
|
| You are hilarious, seriously laughing out loud over here. The databases are definitely different, the one you downloaded is for OLTP (regular, transactional database). What you want is the data warehouse version (hence the DW in the name). I don't know where you can get it, so hopefully someone else can help with that. I would assume it would be installed through the SSAS wizard if you selected samples though, not sure. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-30 : 09:32:37
|
| Looked here?bad link. meant to be http://msdn.microsoft.com/en-us/library/ms143804(v=sql.90).aspx |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
Aleph_0
Yak Posting Veteran
79 Posts |
Posted - 2011-09-30 : 12:18:26
|
| Thanks for the replies - I had actually already visited both links you guys mentioned prior to making this thread. I guess my main question now is which of the files I'm supposed to download if AdventureWorksDB isn't the one I need (and AdventureWorksDW doesn't exist). I'm on 2005, by the way.Thanks again! |
|
|
|
|
|
|
|
|
Downloaded AdventureWorksDB.msi - now what?