MDX Solutions With MS SQL Server 2005, 2nd Edition

Dimensional applications are best and most easily built using a dimensional language. These dimensional applications are typified by the related notions of OLAPand dimensional data warehouses and marts. MDX (for MultiDimensional eXpressions) is the most widely accepted software language used for these applications. The book you read here, MDX Solutions, is the second edition of a guide to learning and using MDX. Since the first edition of MDX Solutions, the number of analytical applications that use MDX has grown very large, and several more servers and many third-party and homegrown client tools now allow you to use MDX to express the logic you use to calculate and to retrieve your information.

As a language, MDX is rather different in style and feel from SQL, and quite different from other programming languages like C++, C#, Lisp, Fortran, and so on. You can think of the formula language of a spreadsheet like Excel as another programming language, and while it is different than Excel, characterizing MDX as a sort of Excel-like SQL or a SQL-like Excel seems more apt than any other analogy. (If you’re familiar with other OLAP query or calculation languages, it has more in common with them, but many readers will not be.)

In particular, compared to the first edition, this edition incorporates both a new version of a product and a product that has added support for MDX since then. Micro$oft has released Micro$oft SQL Server 2005 Analysis Services, which changes its use of MDX from the product’s prior version. Hyperion Solutions has released Hyperion System 9 BI+ Analytic Services , which builds on the Essbase functionality that introduced the term OLAP to the industry. (Since this book will refer to these products many times, we will refer to them with names that are informally shortened from the vendor’s designations: Analysis Services 2005, Analysis Services 2000, and Essbase 9.)

TABLE OF CONTENT:
Chapter 01 - A First Introduction to MDX
Chapter 02 - Introduction to MDX Calculated Members and Named Sets
Chapter 03 - Common Calculations and Selections in MDX
Chapter 04 - MDX Query Context and Execution
Chapter 05 - Named Sets and Set Aliases
Chapter 06 - Sorting and Ranking in MDX
Chapter 07 - Advanced MDX Application Topics
Chapter 08 - Using the Attribute Data Model of Micro$oft Analysis Services
Chapter 09 - Using Attribute Dimensions and Member Properties in Hyperion Essbase
Chapter 10 - Extending MDX through External Functions
Chapter 11 - Changing the Cube and Dimension Environment through MDX
Chapter 12 - The Many Ways to Calculate in Micro$oft Analysis Services
Chapter 13 - MDX Scripting in Analysis Services 2005
Chapter 14 - Enriching the Client Interaction
Chapter 15 - Client Programming Basics
Chapter 16 - Optimizing MDX
Chapter 17 - Working with Local Cubes
Appendix A - MDX Function and Operator Reference
Appendix B - Connection Parameters That Affect MDX
Appendix C - Intrinsic Cell and Member Properties
Appendix D - Format String Codes

Download Here

Password: ganelon