Microsoft® SQL Server® 2008 MDX Step by Step.

Format:

Book

Author/Creator:

Smith, Bryan C.

Contributor:

Clay, C. Ryan.

Consulting, Hitachi.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

MDX (Computer program language).

Relational databases.

Local Subjects:

Client/server computing.

MDX (Computer program language).

Relational databases.

SQL server.

Physical Description:

1 online resource (389 p.)

Edition:

1st edition

Other Title:

Microsoft SQL server 2008 MDX

SQL Server 2008 MDX

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

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 and execute MDX queriesWork with tuples, sets, and expressionsBuild complex sets to retrieve the exact data users needPerform aggregation functions and navigate data hierarchiesAssemble time-based business metricsCustomize an Analysis Se

Contents:

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

Notes:

Description based upon print version of record.

Description based on publisher supplied metadata and other sources.

ISBN:

9780735636545

0735636540

OCLC:

609857195