MDX Solutions: With Microsoft SQL Server Analysis Services Review

Average Reviews:

(More customer reviews)Are you looking to buy MDX Solutions: With Microsoft SQL Server Analysis Services? Here is the right place to find the great deals. we can offer discounts of up to 90% on MDX Solutions: With Microsoft SQL Server Analysis Services. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

MDX Solutions: With Microsoft SQL Server Analysis Services ReviewLet us begin by acknowledging that MDX is a nontrivial topic. With SQL Server 2000 and Analysis Services, Microsoft is providing arguably the most powerful OLAP solution at perhaps the lowest price. But with power comes complexity. Much of this complexity is to be found in the OLAP query language: MDX. Developers will welcome any assistance in climbing this learning curve, and Spofford's book was quick to fill this gap.
This is a thick book, and it is not padded with screenshots of wizards. More than half of the book deals with the syntax and semantics of MDX. It provides a new OLAP sample database for those of us tired of playing with "Foodmart". There are also chapters on local cubes and client programming in ADO. The last quarter of the book is reference material. The MDX function and operator reference in Appendix A includes easily comprehended graphical explanations of function behaviors.
This is not a book geared towards administrators or end users or casual developers. Expect to sweat the details here and to do so from chapter 1. This is a book to read at your computer as you learn the power of MDX by running the examples queries. This author's experience is apparent in the examples, which demonstrate real-world OLAP use cases. Examples range from simple to sophisticated, so this book will useful to both intermediate and advanced MDX programmers.
One weakness of the book is that, since it was written prior to the final release of Analysis Services, there may be some inconsistencies. But the book's web site should post updates and corrections. Also, the book mentions but does not cover the XML for Analysis technology that was released by Microsoft last month (July). XML for Analysis allows SQL Server tables and cubes to be queried using SOAP and XML. Using the WebService Behavior, Internet Explorer can directly make MDX queries and present the results with HTML or graphically (see intrasight.com).
Since MDX has emerged as the defacto standard for OLAP query, all product developers and report developers will want to add this book to their library.
Chris Harrington Active Interface, Inc.MDX Solutions: With Microsoft SQL Server Analysis Services OverviewA hands-on tutorial on building and using multidimensional data warehousesThe SQL query language is used to access data in most simple databases. But for multidimensional (or OLAP) data warehouses, Microsoft developed MDX. The MDX query language has become essential know-how for developers and users alike, whether for data warehouses or for budgeting and planning systems. This tutorial/reference guide shows developers and users how to use MDX to access and analyze data for decision support. Both the standard language and Microsoft's own extensive additions to MDX are explained. The authors provide practical examples of MDX in use, and explain both standard usage and more advanced techniques, such as optimization, cube design, and Pareto analysis. Finally, the appendices provide a handy reference guide that users can rely on.

Want to learn more information about MDX Solutions: With Microsoft SQL Server Analysis Services?

>> Click Here to See All Customer Reviews & Ratings Now