July 30, 2013 at 3:49 pm
I am very new to data warehouse. I just installed Sql server 2008 R2, but when I accessed it, there was no analysis server which is for data warehouse. I also downloaded the Aventure Works DW 2008 database sample, but I did not know where to attach it?
Does anyone know about it?
thank in advance.
July 30, 2013 at 4:06 pm
Which edition of SQL Server 2008 R2 did you install? There is no Analysis Services in Express Edition. If you have Developer, Standard, Enterprise or Evaluation Edition, you can run Setup again to add Analysis Services.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 30, 2013 at 5:22 pm
I am using developer edition. I remembered that I checked on every thing provided and I dont know which one I have missed.
July 31, 2013 at 1:11 am
I forgot to mention: the AdventureWorks2008DW is a regular relational database, so you attach it to the Database Engine like any other database.
As for how to get started with SSAS, I hope someone else can step in, as I have never touched it myself.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply