How do we install the MovieClick database into Analysis Services?

Question

Hi:

I am reading Chapter 4 in "Data Mining with MS SQL Server 2008" and can't seem to find the instructions to install the MovieClick database into an Analysis Service as described on Page 137: "Download the MovieClick database and install it as described in Appendix A". I have restored the .BAK file into the regular SQL server, but that is not enough to follow the examples in the book. I have read Appendix A, and there is no instructions there on how to accomplish this task.   Your help will be greatly appreciated.

Jorge

Answer 1

Hi Jorge,

 

Is there any SSAS project? Restore the .BAK file into the regular SQL server database, after that, open the project, click the data source, edit the connection string, specify the server name. Right click the solution in solution explorer, click properties, specify the target server, and then deploy the project.

 

Other situation:

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

http://msdn.microsoft.com/en-us/library/aa198092(SQL.80).aspx – command line

 

Hope this helps.

Raymond

Answer 2

Hi, Raymond:

Thank you! Your links really helped.

Jorge

Answer 3

Hi, Raymond:

Your links really helped, however, the correct answer to this question, would be to have a link with the errata for the book.  Appendix A has no instructions on how to install the database, and in that errata, Appendix A should include a correction/ammendment instructing how to install the chapter sample databases.

Thank you,

Jorge