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

個数:

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

  • 提携先の海外書籍取次会社に在庫がございます。通常3週間で発送いたします。
    重要ご説明事項
    1. 納期遅延や、ご入手不能となる場合が若干ございます。
    2. 複数冊ご注文の場合は、ご注文数量が揃ってからまとめて発送いたします。
    3. 美品のご指定は承りかねます。

    ●3Dセキュア導入とクレジットカードによるお支払いについて
  • 【入荷遅延について】
    世界情勢の影響により、海外からお取り寄せとなる洋書・洋古書の入荷が、表示している標準的な納期よりも遅延する場合がございます。
    おそれいりますが、あらかじめご了承くださいますようお願い申し上げます。
  • ◆画像の表紙や帯等は実物とは異なる場合があります。
  • ◆ウェブストアでの洋書販売価格は、弊社店舗等での販売価格とは異なります。
    また、洋書販売価格は、ご注文確定時点での日本円価格となります。
    ご注文確定後に、同じ洋書の販売価格が変動しても、それは反映されません。
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 744 p.
  • 言語 ENG
  • 商品コード 9780471748083
  • DDC分類 005.133

Full 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.

Contents

Acknowledgments xxi

Introduction xxiii

Chapter 1 A First Introduction to MDX 1

Chapter 2 Introduction to MDX Calculated Members and Named Sets 37

Chapter 3 Common Calculations and Selections in MDX 61

Chapter 4 MDX Query Context and Execution 97

Chapter 5 Named Sets and Set Aliases 149

Chapter 6 Sorting and Ranking in MDX 161

Chapter 7 Advanced MDX Application Topics 179

Chapter 8 Using the Attribute Data Model of Microsoft Analysis Services 239

Chapter 9 Using Attribute Dimensions and Member Properties in Hyperion Essbase 273

Chapter 10 Extending MDX through External Functions 283

Chapter 11 Changing the Cube and Dimension Environment through MDX 323

Chapter 12 The Many Ways to Calculate in Microsoft Analysis Services 335

Chapter 13 MDX Scripting in Analysis Services 2005 365

Chapter 14 Enriching the Client Interaction 411

Chapter 15 Client Programming Basics 441

Chapter 16 Optimizing MDX 471

Chapter 17 Working with Local Cubes 501

Appendix A MDX Function and Operator Reference 531

Appendix B Connection Parameters That Affect MDX 637

Appendix C Intrinsic Cell and Member Properties 661

Appendix D Format String Codes 675

Index 685

最近チェックした商品