| Description |
1 online resource (1 volume) |
| Contents |
Cover 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 Vocabulary Querying 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 Metadata Referencing Functions in MDX Many Kinds of Ratios, Averages, Percentages, and Allocations Percent Contribution (Simple Ratios between Levels in a Hierarchy) Basic Allocations Averages 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 Context Common 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 Operations Calculating 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 How Long Did It Take to Accumulate This Many? (Building a Set That Sums Backward or Forward in Time) Aggregating by Multiplication (Product Instead of Sum) Including All Tuples with Tied Ranking in Sets Time Analysis Utility Dimensions A Sample Analysis Summary Chapter 8 Using the Attribute Data Model of Microsoft Analysis Services The Unified Dimensional Model (UDM) Dimensions Cubes The Calculation Model in UDM Defining Security on UDM Summary Chapter 9 Using Attribute Dimensions and Member Properties in Hyperion Essbase UDAs and Attributes Retrieving UDAs and Attribute Values on Query Axes Using UDA and Attribute Values in Calculations Selecting Base Dimension Members Based on UDA and Attribute Values Connecting Base Members to the Attribute Hierarchy with IN Summary Chapter 10 Extending MDX through External Functions Using Stored Procedures with MDX ADOMD Server objects AMO .NET Management Stored Procedures Perfor |
| Summary |
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 |
| Notes |
Print version record |
| SUBJECT |
SQL server. http://id.loc.gov/authorities/names/n90684343
|
|
SQL server. blmlsh |
|
SQL server fast |
| Subject |
MDX (Computer program language)
|
|
Client/server computing.
|
|
OLAP technology.
|
|
COMPUTERS -- Programming Languages -- C♯
|
|
COMPUTERS -- Programming Languages -- Java.
|
|
COMPUTERS -- Programming Languages -- Pascal.
|
|
Client/server computing
|
|
MDX (Computer program language)
|
|
OLAP technology
|
| Form |
Electronic book
|
| Author |
Spofford, George, 1965-
|
|
Spofford, George, 1965-
MDX solutions with Microsoft SQL Server Analysis Services
|
| ISBN |
0470007338 |
|
9780470007334 |
|
0471748080 |
|
9780471748083 |
|
