MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, 2/e

George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi

  • 出版商: Wiley
  • 出版日期: 2005-12-01
  • 定價: $1,980
  • 售價: 5.0$990
  • 語言: 英文
  • 頁數: 744
  • 裝訂: Paperback
  • ISBN: 0471748080
  • ISBN-13: 9780471748083
  • 相關分類: MSSQLSQL
  • 立即出貨

買這商品的人也買了...

相關主題

商品描述

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

 

Table of Contents

Acknowledgments.

Introduction.

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.

Index.

商品描述(中文翻譯)

描述

本書既是MDX(多維表達式)查詢語言的教程,也是參考指南,向數據倉庫開發人員展示了他們需要了解的內容,以構建有效的多維數據倉庫。在簡要介紹MDX語言並查看它如何用於訪問複雜的多維數據庫和數據倉庫之後,作者直接提供了MDX實際應用的實例。新的內容涵蓋了MDX語言本身的變化以及最新軟件版本Microsoft SQL Server Analysis Services 2005和Hyperion Essbase中其實現的重大變化。還涵蓋了更高級的技術,如聚合、查詢模板和MDX優化,並向用戶展示了他們需要了解的內容,以訪問和分析數據以做出更好的業務決策。

目錄

致謝

引言

第1章:MDX的初步介紹

第2章:MDX計算成員和命名集的介紹

第3章:MDX中的常見計算和選擇

第4章:MDX查詢上下文和執行

第5章:命名集和集別名

第6章:MDX中的排序和排名

第7章:高級MDX應用主題

第8章:使用Microsoft Analysis Services的屬性數據模型

第9章:在Hyperion Essbase中使用屬性維度和成員屬性

第10章:通過外部函數擴展MDX