Microsoft® SQL Server® 2008 MDX Step by Step (Step By Step (Microsoft)) |  | Authors: Bryan C. Smith, C. Ryan Clay, Hitachi Consulting
Publisher: Microsoft Press
List Price: $49.99
Buy New: $22.55
as of 11/21/2009 21:06 CST details
You Save: $27.44 (55%)
New (30) Used (13) from $22.54
Seller: horizonbb
Rating:  4 reviews
Sales Rank: 80590
Media: Paperback
Edition: Pap/Cdr
Pages: 416
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.2768
EAN: 9780735626188
ASIN: 0735626189
Publication Date: February 18, 2009
Availability: Usually ships in 1-2 business days
| |
| Features:
|
| 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:
It's good to see a book on MDX from MS Press August 6, 2009
N. Erickson (Brisbane, Australia)
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)
3 out of 7 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.
A good foundation March 17, 2009
Eldred Rivera
2 out of 2 found this review helpful
Brian and Ryan presented a very simple and literally step by step way to understand the fundamental syntax of MDX. In addition, the examples are good starting points to be adventurous and to try other stuff. The chapters are arranged in a very logical manner. Each chapter builds upon the knowledge picked-up from the previous one.
However, do not let Chapter 1 discourage you from continuing to explore the rest of the book. The attempt to present the wealth of business intelligence, dimensional model and data warehouse terms and structure may get to be confusing. I agree with them when they wrote that a familiarity of the concept of data warehousing is recommended. To better appreciate the whole exercise of learning MDX, a basic knowledge of Analysis Services will go a long way.
Lastly, finishing the book with a chapter on using MDX with reporting services shows the main purpose of learning MDX in the first place, provide meaningful information to the end users in a format they will appreciate.
Eldred Rivera, MCT
 Best book on mdx in market March 16, 2009
kamran arab (USA)
7 out of 7 found this review helpful
I have read several other texts and I can say that none of them were complete. Some texts had good theory but lacked database sample where you could run the exact same queries, verify results and tinker a little to gain understanding. This book not only comes with a sample database (relational and dimensional), the queries and the databases actually match 100%. Learning Sql or MDX is like learning mathematics - you can't learn it just by reading, exercising the skills is essential.
Step-by-step is very effective approach for new comers so basically this book is ideal for beginners. At the same time it gives you enough details to be an advance user. This book is not for people with MDX skills already under their belt and looking for a reference book. They will be bored with simplistic approach used for beginners. I have been waiting for this book for months and I am not disappointed.
|
|
|
|
