Microsoft SQL Server(tm) 2005 Analysis Services Step by Step [With CDROM]

If just finished chapter 3 and over came an oversite in the book. If you do not see the SSAS Step by Step DW.mdf database file, the following may help. Start the SQL Server Management Studio, Select Server type Database Engine, select the connect button. Within the Object Explorer section, right click on Databases, select Attach. In the new Attach Databasees window, Select the Add button and drill down to where the SSAS Step by Step DW.mdf file is located. You should be back at Attach Databases window. In the bottom half, highlight the 'Log' file type record and select remove (it says 'Not Found' in the Message column). Since there is no log file, we need to remove this action. Select the OK button to attach this database to your other or existing databases. That's it. It worked for me. I hope it works for you. [email protected]

This is a great book to get started with SSAS 2005. Takes you from the very beginnings all the way up to entry level MDX statements. Excellent code samples and sample database to work along with.

Execellent Step by Step book I dont know what all the other reveiws are whining about. M.Anwar states book is boorley written. sb poorly. sigh. Bottom line is the book gets to the point, covers the main topics, and for just 384 pages, (400 is a stretch) does not contain any fat. It usually does a great job in explaining the topics covered. I had a problem with ch6 - aggregrate function - ByAccount , but probably just my fat fingers getting the way. The CD does come with answers, so help is available. The Glossary may be sparse but is very functional. The index details the topics well. I made a few manual entries, but what is perfect. It is better written than most tech books I have. And W.Salkin states book has (no .ldf). not true. I had isses reading cd on my computer so I installed on another computer, copied files and continued on just fine. And Jon Anderson - the book does state on the title - "Step by Step" , does explain the steps very well, at least to me. you're right, MDX can be confusing, and it was a little hard to grasp. page 188 states that unless you're creating a custom report generator, you'll probably have little occasion to write MDX, BUT, knowing will enable you to understand clearly what the subquery is doing. And K.Johnson - had problems with ch 3 Schema Gen Wizard. I did not, Kind of surprised, but had problems elsewhere, but just looked at the answers folder. Wole Babalola had database attach problems. I did to but once I got past it, found the book to be very very good. would be nice to have a web site to download code from. This is an execellent book to get you started, and show you the 101 steps of ssas.

I am not sure why some people had problem following the examples or used the CD. I haven't had any issue except write-back excel example in chap 10 and some mismatched data in chap 9 (account dimension). The book is very helpful in building your understanding by working the examples step by step. It explains most concepts in SSAS clear and interesting to learn. Right after I finished the book, I was able to utilize the knowledge in a small scale SSAS project. Even now I have purchased and studied several other SSA books, this is still the book I enjoy the most.

Very easy to follow. Great for a beginner. Quick read, great examples.