MDX solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase / George Spofford ... [et al.].

Format:

Book

Contributor:

Spofford, George, 1965-

Language:

English

Subjects (All):

SQL server.

MDX (Computer program language).

Client/server computing.

OLAP technology.

Physical Description:

1 online resource (746 p.)

Edition:

2nd ed.

Place of Publication:

Indianapolis, IN : Wiley Pub., c2006.

Language Note:

English

System Details:

text file

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 warehousesAfter 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 useNew material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases

Contents:

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

Notes:

Rev. ed. of: MDX solutions with Microsoft SQL Server Analysis Services / George Spoffrod. 2001.

Includes index.

Related Work:

Spofford, George, 1965- MDX solutions with Microsoft SQL Server Analysis Services.

ISBN:

9786610349616

9781280349614

1280349611

9780470007334

0470007338

OCLC:

70002782