MDX Solutions and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
Sorry!
More Buying Choices
51 used & new from $24.95

Have one to sell? Sell yours here
 
   
MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
 
 
Start reading MDX Solutions on your Kindle in under a minute.

Don’t have a Kindle? Get your Kindle here.
 
  

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase (Paperback)

~ George Spofford (Author), Sivakumar Harinath (Author), Christopher Webb (Author), Dylan Hai Huang (Author), Francesco Civardi (Author) "This first chapter introduces the syntax and semantics of the MDX (MultiDimensional expressions) language, looking at basic queries and the language's modular nature..." (more)
Key Phrases: Avg Sales Price, Customer Geography, Visual Studio (more...)
4.3 out of 5 stars  See all reviews (11 customer reviews)

List Price: $60.00
Price: $54.00 & this item ships for FREE with Super Saver Shipping. Details
You Save: $6.00 (10%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, November 10? Choose One-Day Shipping at checkout. Details
35 new from $33.79 16 used from $24.95

Formats

Amazon Price New from Used from
  Kindle Edition, March 6, 2006 $43.18 -- --
  Paperback, March 5, 2006 $54.00 $33.79 $24.95

Frequently Bought Together

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase + Fast Track to MDX + Microsoft SQL Server 2005 Analysis Services
Price For All Three: $135.63

Show availability and shipping details

  • This item: MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase by George Spofford

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Fast Track to MDX by Mark Whitehorn

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Microsoft SQL Server 2005 Analysis Services by Edward Melomed

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

Microsoft® SQL Server® 2008 MDX Step by Step (Step By Step (Microsoft))

Microsoft® SQL Server® 2008 MDX Step by Step (Step By Step (Microsoft))

by Bryan C. Smith
3.8 out of 5 stars (4)  $31.49
Microsoft SQL Server 2005 Analysis Services

Microsoft SQL Server 2005 Analysis Services

by Edward Melomed
3.8 out of 5 stars (18)  $43.86
The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

by Joy Mundy
4.4 out of 5 stars (21)  $42.50
Microsoft SQL Server 2008 Analysis Services Unleashed

Microsoft SQL Server 2008 Analysis Services Unleashed

by Irina Gorbach
3.4 out of 5 stars (9)  $37.79
Applied Microsoft Analysis Services 2005: And Microsoft Business Intelligence Platform

Applied Microsoft Analysis Services 2005: And Microsoft Business Intelligence Platform

by Teo Lachev
4.5 out of 5 stars (23)  $32.97
Explore similar items

Editorial Reviews

Product Description

  • Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses
  • After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move directly to providing practical examples of MDX in use
  • New material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
  • Also covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.



From the Back Cover

An updated version of the leading tutorial and reference on the MDX query language

Now in its second edition, this invaluable reference explains why MDX (MulitDimensional eXpressions) is the most widely accepted software used for dimensional application. You'll learn how to build effective multidimensional data warehouses and you'll gain the necessary skills to access and analyze data to make better business decisions.

After a brief overview of the syntax and semantics of the MDX language, the authors move directly to the tutorial, providing practical examples of MDX in use. With more than 60 percent revised and updated content, this new edition addresses the increased number of analytical applications that use MDX. The authors cover both the changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase.

This unrivaled book includes:

  • The range of possibilities specific to Microsoft and Hyperion
  • Techniques and tricks of combining the different functions of MDX to solve a variety of problems
  • Capabilities of SQL Server 2005 Analysis Services, and how its relationship with MDX has changed from the prior version
  • The standard syntax of MDX that handles the constructs and capabilities of numerous servers
  • Detailed reference appendices for MDX operators, functions, and related connection settings

The companion Web site includes a collection of sample databases and code for use in Analysis Services and Essbase, and an MDX query interface for Essbase.


Product Details

  • Paperback: 744 pages
  • Publisher: Wiley; 2 edition (March 6, 2006)
  • Language: English
  • ISBN-10: 0471748080
  • ISBN-13: 978-0471748083
  • Product Dimensions: 9 x 7.4 x 1.7 inches
  • Shipping Weight: 2.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon.com Sales Rank: #250,241 in Books (See Bestsellers in Books)

    Popular in these categories: (What's this?)

    #51 in  Books > Computers & Internet > Databases > Data Warehousing
    #88 in  Books > Computers & Internet > Microsoft > Development > SQL Server

Inside This Book (learn more)


Books on Related Topics (learn more)
 
MDX Solutions by George Spofford
 

What Do Customers Ultimately Buy After Viewing This Item?

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
69% buy the item featured on this page:
MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase 4.3 out of 5 stars (11)
$54.00
Fast Track to MDX
14% buy
Fast Track to MDX 4.1 out of 5 stars (34)
$37.77
Microsoft® SQL Server® 2008 MDX Step by Step (Step By Step (Microsoft))
8% buy
Microsoft® SQL Server® 2008 MDX Step by Step (Step By Step (Microsoft)) 3.8 out of 5 stars (4)
$31.49
Microsoft SQL Server 2005 Analysis Services
5% buy
Microsoft SQL Server 2005 Analysis Services 3.8 out of 5 stars (18)
$43.86

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(3)
(1)

Your tags: Add your first tag
 

 

Customer Reviews

11 Reviews
5 star:
 (7)
4 star:    (0)
3 star:
 (4)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.3 out of 5 stars (11 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
41 of 41 people found the following review helpful:
5.0 out of 5 stars The [MDX] Bible just got better, April 12, 2006
The first edition of MDX Solutions is without a doubt the MDX bible. My copy goes with me wherever I may encounter any MDX-writing requirements. It is by far the most tattered, thumbed-through textbook I own.

From a purely superficial perspective the second edition is about 40% bigger than the original. Just from the size difference alone I am surprised they would consider this a second edition. Did they just keep the title for name recognition? Probably a wise idea. I would almost class this as first edition; a new book.

As the new title suggests the book covers both Microsoft Analysis Services 2005 and Hyperion Essbase's implementation of the MDX specification. Both products and their subtle differences are detailed clearly and wherever possible. There are plenty of product-specific hints, tips & code samples throughout the book. In actual fact you could say that the book actually covers three products if you count AS2000 as a product unto itself. Naturally AS2000 takes a back seat to SSAS but there is still plenty in there.

The tone of the book is balanced so as not to be partial to one product over the other, it simply tells it like it is: Microsoft does it this way, Hyperion does it that way. In a few areas the authors give examples of particular functions/features that may exist in one product but not the other. This is often followed by details of techniques to mimic that behaviour in the other product. A good example of this is Member aliasing (p.158).

Where appropriate complete chapters are dedicated to the specifics of one particular product but mostly are covered together where they share a common MDX foundation. Because of the UDM and attribute-based dimensional model a chapter has been dedicated to going over the new SSAS architecture. Hyperion's User Defined Attributes (UDAs) also has its own chapter.

If you liked the first edition because of its depth of detail and relevant examples you will not be disappointed, this one goes even deeper. I think I could almost feel some of the pain the authors went through as they tried, as succinctly and clearly as possible, to explain some particularly complex concepts within several short paragraphs and a few code samples. Even more so than its predecessor this book *will* make your brain hurt.

To me one of the hallmarks of a good technical book is that it contains information that is simply not available anywhere else i.e. you're getting good value for your money. The book details some MDX features that do not even get a mention in the current (Dec '05) BOL (don't know about Essbase documentation...). Best example is the HAVING clause, the only other place I was able to find any information about this new language feature was on co-author Chris Webb's blog. Ken Henderson's SQL 2000 Guru's Guides were also great examples of "stuff you won't find in BOL or anywhere else".

If I had a criticism of the book it would be (and I am nit-picking here) that on a few occasions sample code is presented containing a concept or syntax shortcut that has not been fully explained to the reader in preceding chapters.

Often appendices get written but never really read and are rarely referenced. Some technical appendices don't really add much value to what you can already find on line or in help files. I often wonder whether some are just put there to, y'know provide a bit of padding to get the publication into the "bloody big technical book" category. To me probably the most valuable part of both versions of MDX Solutions is Appendix A . It is the back of the book that really promotes it to Bible status. Appendix A in this edition now has a 100 page Function and Operator Reference (the original was about 70 pages). MDX function documentation of this quality does not exist anywhere else, not in BOL, not anywhere.

One of the reasons there aren't as many people in the world who use MDX to its fullest is because the underlying concepts take a while to grasp. Many become disillusioned early on and say "I'll just do it in T-SQL, it's easier for me." George et al have tried to provide a little more beginner detail in the first few chapters of this edition, nonetheless the book still goes deep quite quickly. Beginners to MDX could potentially get lost whilst still trying to come to grips with the basic concepts of tuples and sets before being thrown in the multi-dimensional deep end. If you are an OLAP novice or someone who has never written any MDX at all then this is not the book for you to start on. Don't get me wrong, you should still get a copy just don't read it *first*. I would recommend beginning with some lighter MDX reading. "Fast Track to MDX Second Edition" may help ease you into the MDX world without drowning in a sea of square and curly braces. Admittedly, it is based on AS2000 but the essence of MDX itself has not changed between 2000 and 2005, everything is still tuples, sets and axes. "Fast Track" is a smaller book, a lighter read and will serve to get you in the right mind set. So buy both books, read Fast Track first and *then* take MDX Solutions Second Edition off the shelf - you will get much more out of it. If you need more of an overall OLAP base with a bit of MDX mixed in then get a copy of Teo Lachev's "Applied Microsot Analysis Services 2005"

If you own the MDX Solutions first edition and were tossing up whether to get a copy of the latest let me put your mind at ease in that this is, in essence, a new book. Sure you'll see some of the same chapter and section headings and recognise some of the text from the original book but that is pretty-much where it ends. The 300-ish new pages are certainly not padding, the new MDX features and nuances are covered along with even more detail on the ones we already know. If you are committed to making the most of OLAP technology and hence MDX then you will want a copy of this book. Whether you are going to use MDX on the odd occasion or design and build a full-blown OLAP browsing app there is no other equivalent end-to-end MDX publication available. The only other book which comes remotely close is the first edition.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
5 of 5 people found the following review helpful:
3.0 out of 5 stars Reference Book with Little Competition, September 18, 2006
MDX Solutions is an essential reference book for anyone using Analysis Services 2005. No other book covers the subject as thoroughly as this one. However, it remains only a reference book. It is thick, extremely dense, and not a tutorial that you can read cover to cover. Believe me; I've tried, more than once in fact.

It's five authors are experts on MDX and know their stuff, but unfortunately there is no correlation between their raw knowledge and the ability to teach the subject in a step-wise, easy-to-follow manner for someone new to MDX. The text is dense and the examples often difficult to follow. That said, you will need this book if you are planning to do very much MDX programming simply because as of this writing there not better alternatives out there. I wish there were.

A lot of time has obviously been put into this book and I applaud the authors for sharing as much as they have; however, it's very unfortunate that the authors didn't have it edited by multiple reviewers new to MDX who could have turned the book into a better tutorial.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
2 of 2 people found the following review helpful:
3.0 out of 5 stars Issues with samples, September 19, 2007
My biggest problem is that I am unable to execute most of the samples because of the "dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified" issue - a behavior change in SSAS 2005. Very frustrating. Are there any corrected samples available for download anywhere?
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Perhaps the only MDX book you'll need
This is a fantastic reference guide, with clear, easy to read samples and great description about MDX language concepts, terms, functions & syntax. Read more
Published 20 days ago by nine.jack.nine

5.0 out of 5 stars Most Definitive Guide on the Subject
This book is the most definitive guide on the subject of MDX. The book is very well organized and the examples are practical and make perfect sense. Read more
Published 1 month ago by Abhishek Srivastava

3.0 out of 5 stars Great book but many of the examples doesn't run properly.
This book is the best MDX I have ever read and is deserving a 5 star rating; however, I, like many others, am unable to execute most of the samples because of the "dimension... Read more
Published 2 months ago by Thong Q. Tran

5.0 out of 5 stars Excellent Learning Material
I have read several MDX related books and there are in my opinion three categories of those: books where MDX is a "byproduct" focused mainly on OLAP, books that are fascinated by... Read more
Published 10 months ago by Peter Dolina

5.0 out of 5 stars the best MDX book
This is the best MDX book available as far as I know. I read several other analysis services and MDX related books and articles but if you are working on a project that uses any... Read more
Published 14 months ago by Cagdas Ucar

3.0 out of 5 stars Not Good If You're New to MDX
I think that this book is probably not for the beginning MDX developer. I am having trouble getting the examples to work, perhaps because the full text of the example is normally... Read more
Published 20 months ago by C. D. Waage

5.0 out of 5 stars excellent book for mdx
I am new to MDX and found this book very useful. It is very readable, provides excellent explanation of technical topics and lots of examples. Read more
Published on July 18, 2007 by H. Khan

5.0 out of 5 stars MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
If you are looking for mastering in MDX, this is your book. Highly recommended for begginers and advanced users. Good examples. Read more
Published on November 4, 2006 by Alan D. Koo Labrin

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Discussion Replies Latest Post
Textbooks for Kindle DX? 61 23 hours ago
textbook scam 66 5 days ago
Amazon is a great place to buy textbooks! 35 17 days ago
Search Customer Discussions
Search all Amazon discussions
   




Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.