|
Microsoft SQL Server 2008 MDX Step by Step (Step By Step (Microsoft)) |  | Authors: Bryan C. Smith, C. Ryan Clay, Hitachi Consulting
Publisher: Microsoft Press
Category: Book
List Price: $49.99
Buy New: $27.19
as of 7/30/2010 03:41 CDT details
You Save: $22.80 (46%)
New (31) Used (9) from $26.94
Seller: balkanika
Rating:  7 reviews
Sales Rank: 128297
Media: Paperback
Edition: 1
Pages: 400
Number Of Items: 1
Shipping Weight (lbs): 2.1
Dimensions (in): 8.9 x 7.4 x 1.3
ISBN: 0735626189
Dewey Decimal Number: 005.2
EAN: 9780735626188
ASIN: 0735626189
Publication Date: February 25, 2009
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: - Construct and execute MDX queries
- Work with tuples, sets, and expressions
- Build complex sets to retrieve the exact data users need
- Perform aggregation functions and navigate data hierarchies
- Assemble time-based business metrics
- Customize an Analysis Services cube through the MDX script
- Implement dynamic security to control data access
- Develop MDX-driven reports in SQL Server Reporting Services
CD features: - Practice exercises
- Database and code samples
- Fully searchable eBook
|
| Customer Reviews:
Showing reviews 1-5 of 7
 Hard to beat April 16, 2010
Jaewoo Kim (Santa Monica, CA)
1 out of 1 found this review helpful
If you are a beginner to intermediate MDX person, then I can't think of any better book on the subject. Don't let the "step-by-step" label misguide you into believing this book is only for the beginners. This book covers from the simple to the complex MDX queries.
The book deals from the very basic "Select { } on columns, { } on rows from [Cube]" to using Expressions, Aggregation, and navigating the hierarchies. You will learn to use all MDX keywords, functions, and syntax structures.
I would not recommend this book as a first book on SQL BI (I like Brian Larson's "Delivering Business Intelligence"). Rather, this book should be an important supplement to anyone's SQL BI knowledge. Although SQL 2008 provides a handy GUI to build a MDX queries on an existing cube, it is not a good substitute for complex MDX queries. Trust me, when the pressure is on, and the senior management wants to get key information in a hurry, understanding MDX well can save you a lot of stress and reduce the blame game so prevalent in IT.
If you are never going to use MDX, I would question the need to build and process Cubes (also called Data Mart) all together. If you have a solidly designed Data Warehouse and a well functioning ETL process, you can just query the DW using SQL for most of the information you would need. But MDX releases the potential of the Cube and makes the entire SQL BI, and the Cube in particular, far more valuable and usable.
MDX is used across multiple Business Intelligence platforms. Even if you do not plan to exclusively use SQL BI, this book will help you to understand MDX that you can apply to, let's say, Microstrategy and SAS.
This book also comes with a CD that provides sample SQL BI Development Project and a corresponding Data Warehouse database.
If you want a well written, highly structured, and clear explanations of MDX from simple to complex, then this book is the right book for you.
opinion sobre sql server 2008 mdx December 15, 2009
Andres Williams Herrera (madrid, madrid, ES)
0 out of 1 found this review helpful
El libro es excelente, permite introducirse en el tema desde cero y llegar a un nivel intermedio-alto. Lo recomiendo a todo el que quiera adentrarse en este tema
Good for new learner December 4, 2009
Jing Shao (Penang, Malaysia)
2 out of 2 found this review helpful
This book is good start for new learner. However, if u looking of optimization and very tricky situation, this may not suite you.
It's good to see a book on MDX from MS Press August 6, 2009
N. Erickson (Brisbane, Australia)
2 out of 2 found this review helpful
It's SQL Server 2008 MDX Step by Step and it delivers what you need to get your teeth into MDX. In the way most Step by Step books from Microsoft Press do, but I probably wouldn't recommend the book to people already fluent with MDX.
 Good luck with CD installation June 9, 2009
Victor Sobolev (San Jose, Califonia)
5 out of 11 found this review helpful
This book is meant to follow examples step-by-step, which means the sample databases have to be installed first. The instruction tells you to take the CD, and install two samples. It goes in great detail explaining that C:drive letter may need to be changed to D: (repeated 4 times), but it does not give you a slightest hint that different processes of SQL Server use different autentication regardless of your login name, and you need to give these permissions to the sample source files.
After spending several hours googling and experimenting, I got thru with permissions; fixed the problem with the log file (the only one mentioned on-line for book support), managed to load the first database, and got stuck with all kind of error messages loading the analysis services database.
Without the source code the only option was to send an email to Microsoft Support team. All I got back is auto-reply, so instead of studying the new language I spend days waiting.
Unless you are a SQL Server DBA who loves debugging for fun, pick something else.
Showing reviews 1-5 of 7
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
