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
買這商品的人也買了...
-
CCNA Self-Study: Interconnecting Cisco Network Devices (ICND) 640-811, 640-801, 2/e$2,330$2,214 -
JSP 2.0 技術手冊$750$593 -
深入淺出設計模式 (Head First Design Patterns)$880$695 -
深入淺出 Java 程式設計, 2/e (Head First Java, 2/e)$880$581 -
紅色風暴 II 3ds max 室內設計實例教程－渲染篇$790$672 -
3ds Max 8 入門與實例$650$553 -
SQL Server 2005 資料庫開發聖經$890$757 -
如何設計好網站 (Don't Make Me Think: A Common Sense Approach to Web Usability, 2/e)$450$405 -
$399The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset -
鳥哥的 Linux 私房菜基礎學習篇, 2/e$780$702 -
Microsoft SQL Server 2005 設計實務$680$578 -
駭客攻防技術擂臺$520$442 -
專案管理之美學 (The Art of Project Management)$620$490 -
Ajax 網頁程式設計─Google 成功背後的技術$580$493 -
Ajax 與 Google Map API 入門實作$450$351 -
最新 JavaScript 與 Ajax 範例活用辭典$390$304 -
ASP.NET 2.0 深度剖析範例集$650$507 -
Microsoft SQL Server 2005 管理實務$680$578 -
Linux 驅動程式, 3/e (Linux Device Drivers, 3/e)$980$774 -
Dreamweaver 搞不定的網頁設計效果：CSS 關鍵救援密碼$520$442 -
Ajax 實戰手冊 (Ajax in Action)$680$537 -
時間管理─給系統管理者 (Time Management for System Administrators)$480$379 -
Ajax 快速上手 (Head Rush Ajax)$780$616 -
臥龍小三的 B2D Server 快速入門$680$612 -
聖殿祭司的 ASP.NET 2.0 專家技術手冊─使用 C#$720$569
商品描述
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
