MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, 2nd Edition
- 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.
Chapter 1:Â A First Introduction to MDX.
Chapter 2: Introduction to MDX Calculated Members and Named Sets.
Chapter 3: Common Calculations and Selections in MDX.
Chapter 4: MDX Query Context and Execution.
Chapter 5: Named Sets and Set Aliases.
Chapter 6: Sorting and Ranking in MDX.
Chapter 7: Advanced MDX Application Topics.
Chapter 8: Using the Attribute Data Model of Microsoft Analysis Services.
Chapter 9: 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 Microsoft 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.
|SQL: Databases for Chapter 13|
Download the databases for Chapter 13 (MDX Scripting).
|SQL: Waremart 2005 database|
Download the Waremart 2005 database used as an example in much of the book.
|System 9: WM2005 Database||Download|
|System 9: Interactive MDX Query Tool|
Download an interactive MDX query tool for System 9 databases. THIS SOFTWARE IS PROVIDED "AS IS" WITHOUT WARRANTIES OF ANY KIND. HYPERION DOES NOT WARRANT THAT THE OPERATION OF THE SOFTWARE WILL BE UNINTERRUPTED OR ERROR-FREE. HYPERION DISCLAIMS ALL OTHER WARRANTIES OR CONDITIONS, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO, WARRANTIES OR CONDITIONS OF MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE. HYPERION SHALL NOT BE LIABLE FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE HEREOF.
|Web Updates - Chapter 10|
These updates are in a .zip format archive. You might need a copy of WinZip to open them.