| | |  | Software Engineering | Home » » » Microsoft® SQL Server(TM) 2005 Analysis Services Step by Step (Step by Step (Microsoft)) | | | | | | | Description: | | Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization. Discover how to: - Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers
- Create dimensions and measure groups to build, browse, and modify OLAP cubes
- Design objects to handle unique financial analysis requirements
- Improve query performance with aggregations and user hierarchies
- Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques
- Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes
- Manage role-based security and restrict data access
- Deploy and maintain a database in a production environment
CD features - All practice exercises and answer files
- Fully searchable eBook
A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
| | | Features: | |
• ISBN13: 9780735621992
• Condition: New
• Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
| | | Product Details: | | | Author:
| Reed Jacobson | | Paperback:
| 400 pages | | Publisher:
| Microsoft Press | | Publication Date:
| April 26, 2006 | | Language:
| English | | ISBN:
| 0735621993 | | Product Length:
| 8.86 inches | | Product Width:
| 7.7 inches | | Product Height:
| 1.02 inches | | Product Weight:
| 1.76 pounds | | Package Length:
| 8.9 inches | | Package Width:
| 7.4 inches | | Package Height:
| 1.02 inches | | Package Weight:
| 1.81 pounds | | Average Customer Rating:
|  based on 15 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 15 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
7 of 7 found the following review helpful:
Quick Overview of the EssentialsSep 10, 2007
By Random Feature
"Random Feature"
This book is centered on its step by step instuctions which demonstrate the features of Analysis Services. It is best to follow the instructions by performing them in Visual Studio. I had no trouble installing the database using the CD-Rom as provided by Safari which includes an MDF file and SQL script.
A postitive is that there is very little fluff in this book, it lists the steps and explains the concepts without going into great detail. In fact, I would prefer a little more explanation of what's going on under the hood, but at the same time it is nice not to get bogged down in a large highly detailed book. This is a good introduction to Analysis Services but will not make you an expert.
15 of 19 found the following review helpful:
 I'm shockedJun 24, 2006
By Laurence M. Schwarz
"Business Intelligence Consultant"
I am both shocked and surprised at how completely faulty this book is. I have the previous version of this book; Microsoft SQL Server 2000 Analysis Services Step by Step, and I don't remember it being this bad. Don't get me wrong, I know Reed Jacobson as I had met him at the SQL Server 2005 launch event, and I don't necessarily blame him for the poor standing. I do however blame Microsoft as there is no way they could have performed any sort of Technical Editorial on this book. If you do decide to buy it, watch out for the Writeback partitions exercise in Chapter 10. It blew up my Virtual Server. Twice.
13 of 17 found the following review helpful:
 A troubled workJun 27, 2006
By W. Salkin
Chapter 1 made several good points. Chapter 2 was more confusing in its presentation but I got something out of it. Chapter 3 began the hands-on so I installed the sample files and sample database contained on the accompanying CD-ROM -- only to find that I couldn't successfully install the database! The CD contains only the ".mdf" file for the sql database (no .ldf), not enough to "restore" or "attach" the database. Their script to install the DB also errored out. I was unable to locate any useful help or errata on the MsPress website. It looks like the authors spent a lot of time and effort developing the step-by-step examples so I'm quite disappointed that I can't proceed further into chapter 3. I'd recommend looking to the Microsoft SSAS tutorial instead of this book.
2 of 2 found the following review helpful:
 chap 3 page 52Nov 18, 2008
By Valerie A. Pettigrew
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.
Randie@thepettigrews.com
2 of 2 found the following review helpful:
Ran into a problem early in the bookJan 17, 2008
By K. Johnson
"True Worshipper"
I ran into a problem early in the book in Chapter 3 going through the Schema Generation Wizard. I went through the steps and it said cannot find the matching TimeAttributeType. Now I'm stuck!
See all 15 customer reviews on Amazon.com
| | |
|
