Microsoft® SQL Server® 2008 MDX Step by Step
Teach yourself the Multidimensional Expressions (MDX) query language-one step at a time. With this practical, learn-by-doing tutorial, you'll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: Construct...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627947006719 |
Tabla de Contenidos:
- Cover; Copyright Page; Dedication; Contents at a Glance; Table of Contents; Acknowledgements; Introduction; Who This Book Is For; What This Book Is About; Conventions and Features in This Book; Conventions; Other Features; System Requirements; Samples; Installing the Samples; Uninstalling the Samples; Find Additional Content Online; Support for This Book; Questions and Comments; Part I: MDX Fundamentals; Chapter 1: Welcome to MDX; The Business Intelligence Landscape; The Dimensional Model; Implementing the Dimensional Model; The Relational Data Warehouse; The Multidimensional Data Warehouse
- The MDX LanguageChapter 1 Quick Reference; Chapter 2: Using the MDX Query Editor; SQL Server Management Studio; The MDX Query Editor; Building a Simple MDX Query; Exploring the Step-by-Step Cube; Building a More Complex Query; Chapter 2 Quick Reference; Chapter 3: Understanding Tuples; N-dimensional Space; Cube Space; Accessing Data with Tuples; Understanding Cells; Working with Partial Tuples; Building Tuples with User-Hierarchies; Understanding User-Hierarchy Translation; Avoiding Reference Conflicts; Member Reference Shortcuts; Chapter 3 Quick Reference; Chapter 4: Working with Sets
- Set BasicsUnderstanding the SELECT Statement; Building Sets with Functions; The Members Function; The Crossjoin Function; Limiting Sets; Working with Auto-Exists; The Exists Function; Chapter 4 Quick Reference; Chapter 5: Working with Expressions; Expression Basics; Calculated Members; Building Dynamic Expressions; Resolving Contextual Conflicts; Avoiding Infinite Recursion; Controlling Solve Order; Building Complex Expressions; Working with the Current Member; Working with Sets in Expressions; Chapter 5 Quick Reference; Part II: MDX Functions; Chapter 6: Building Complex Sets
- Assembling Ordered SetsRetrieving the First or Last Tuples of a Set; Filtering Sets; Combining Sets; Performing Advanced Set Construction; Assembling Sets with the Generate Function; Assembling Sets with the Extract Function; Chapter 6 Quick Reference; Chapter 7: Performing Aggregation; Performing Summation; Calculating Averages; Calculating Averages with the Avg Function; Calculating Averages with Expressions; Identifying Minimum and Maximum Values; Counting Tuples in Sets; Chapter 7 Quick Reference; Chapter 8: Navigating Hierarchies; Accessing Immediate Relatives
- Accessing Extended RelativesNavigating within a Level; Chapter 8 Quick Reference; Chapter 9: Working with Time; Understanding the Time Dimension; Calculating an Accumulating Total; Calculating Rolling Averages; Performing Period-over-Period Analysis; Combining Time-Based Metrics; Chapter 9 Quick Reference; Part III: MDX Applications; Chapter 10: Enhancing the Cube; Understanding the MDX Script; Constructing Calculated Members; Assembling a Basic Calculated Member; Setting Calculated Member Properties; Assembling Named Sets; Chapter 10 Quick Reference; Chapter 11: Implementing Dynamic Security
- Understanding Dynamic Security
