MDX solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
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 warehousesAfter a brief overview of the MDX language and a look at how it is used to ac...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub
c2006.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626972806719 |
Tabla de Contenidos:
- MDX Solutions Second Edition With Microsoft® SQL ServerTM Analysis Services 2005 and Hyperion® Essbase; About the Authors; Credits; Contents; Acknowledgments; Introduction; Overview of the Book and Technology; How This Book Is Organized; What's Not in This Book; Who Should Read This Book; Tools You Will Need; What's on the Web Site; Summary; Chapter 1 A First Introduction to MDX; What Is MDX?; Query Basics; Axis Framework: Names and Numbering; Case Sensitivity and Layout; Simple MDX Construction; Removing Empty Slices from Query Results; Comments in MDX; The MDX Data Model: Tuples and Sets
- More Basic VocabularyQuerying for Member Properties; Querying Cell Properties; Client Result Data Layout; Summary; Chapter 2 Introduction to MDX Calculated Members and Named Sets; Dimensional Calculations As Calculated Members; Calculated Member Scopes; Basic Calculation Functions; Additional Functions; Introduction to Named Sets; Summary; Chapter 3 Common Calculations and Selections in MDX; Time-Based References and Time-Series Calculations; Using LastPeriods() to Select Time Ranges Based on a Target Member; Different Aggregations along Different Dimensions (Semi-Additive Measures Using MDX)
- Using Member Properties in MDX Expressions (Calculations and Sorting)Handling Boundary Conditions (Members out of Range, Division by Zero, and More); Summary; Chapter 4 MDX Query Context and Execution; Cell Context and Resolution Order in Queries; Modifying the Cube Context in AS2005; Nondata: Invalid Numbers, NULLs, and Invalid Members; Precedence of Cell Properties in Calculations; Cube Context in Actions; Cube Context in KPIs; Visibility of Definitions between Global, Session, and Query-Specific Calculations in Analysis Services 2005; Summary; Chapter 5 Named Sets and Set Aliases
- Named Sets: Scopes and ContextCommon Uses for Named Sets; Set Aliases; Summary; Chapter 6 Sorting and Ranking in MDX; The Function Building Blocks; Classic Top-N Selections; Getting the Fewest/Most Tuples to Reach a Threshold; Retrieving the Top N Percent of Tuples; Putting Members/Tuples in Dimension Order (Ancestors First or Last); Reversing a Set; Summary; Chapter 7 Advanced MDX Application Topics; Arranging Parents/Ancestors after Children, Not Before; Returning the Subtree under a Member and the Ancestors of That Member Along with the Member
- Using Generate() to Turn Tuple Operations into Set OperationsCalculating Dates/Date Arithmetic; Defining Ratios against the Members Selected on Rows/Columns/Axes, Instead of against a Specific Dimension; Report-Based Totals-to-Parent, Percentage Contribution to Report Totals; Hierarchical Sorting That Skips Levels in the Hierarchy; Sorting a Single Set on Multiple Criteria; Multiple Layers or Dimensions of Sorting; Pareto Analysis and Cumulative Sums; Returning the Top-Selling Product (or Top-Selling Month or Other Most-Significant Name) As a Measure
- Most Recent Event for a Set of Selected Members
