book

Microsoft® SQL Server® 2008 MDX Step by Step

by C Ryan Clay Bryan C Smith and Hitachi Consulting

February 2009

Beginner to intermediate

400 pages

9h 59m

English

Microsoft Press

Read now

Unlock full access

Who This Book Is ForWhat This Book Is AboutConventions and Features in This BookConventionsOther FeaturesSystem RequirementsSamplesInstalling the SamplesUninstalling the SamplesFind Additional Content OnlineSupport for This BookQuestions and Comments
The Business Intelligence LandscapeThe Dimensional ModelImplementing the Dimensional ModelThe Relational Data WarehouseThe Multidimensional Data WarehouseThe MDX LanguageChapter 1 Quick Reference
SQL Server Management StudioThe MDX Query EditorBuilding a Simple MDX QueryExploring the Step-by-Step CubeBuilding a More Complex QueryChapter 2 Quick Reference
N-dimensional SpaceCube SpaceAccessing Data with TuplesUnderstanding CellsWorking with Partial TuplesBuilding Tuples with User-HierarchiesUnderstanding User-Hierarchy TranslationAvoiding Reference ConflictsMember Reference ShortcutsChapter 3 Quick Reference
Set BasicsUnderstanding the SELECT StatementBuilding Sets with FunctionsThe Members FunctionThe Crossjoin FunctionLimiting SetsWorking with Auto-ExistsThe Exists FunctionChapter 4 Quick Reference
Expression BasicsCalculated MembersBuilding Dynamic ExpressionsResolving Contextual ConflictsAvoiding Infinite RecursionControlling Solve OrderBuilding Complex ExpressionsWorking with the Current MemberWorking with Sets in ExpressionsChapter 5 Quick Reference

Assembling Ordered SetsRetrieving the First or Last Tuples of a SetFiltering SetsCombining SetsPerforming Advanced Set ConstructionAssembling Sets with the Generate FunctionAssembling Sets with the Extract FunctionChapter 6 Quick Reference
Performing SummationCalculating AveragesCalculating Averages with the Avg FunctionCalculating Averages with ExpressionsIdentifying Minimum and Maximum ValuesCounting Tuples in SetsChapter 7 Quick Reference
Accessing Immediate RelativesAccessing Extended RelativesNavigating within a LevelChapter 8 Quick Reference
Understanding the Time DimensionCalculating an Accumulating TotalCalculating Rolling AveragesPerforming Period-over-Period AnalysisCombining Time-Based MetricsChapter 9 Quick Reference
Understanding the MDX ScriptConstructing Calculated MembersAssembling a Basic Calculated MemberSetting Calculated Member PropertiesAssembling Named SetsChapter 10 Quick Reference
Understanding Dynamic SecurityImplementing Attribute-Hierarchy RestrictionsRestricting Standard Attribute-HierarchiesRestricting Parent-Child HierarchiesImplementing Cell-Level RestrictionsChapter 11 Quick Reference
Getting StartedConnecting to Analysis ServicesDesigning the DatasetAdding Parameters to the DatasetPresenting the Data in the ReportChapter 12 Quick Reference
Bryan C. SmithC. Ryan ClayHitachi Consulting

Overview

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 queries

Work with tuples, sets, and expressions

Build complex sets to retrieve the exact data users need

Perform aggregation functions and navigate data hierarchies

Assemble time-based business metrics

Customize an Analysis Services cube through the MDX script

Implement dynamic security to control data access

Develop MDX-driven reports in SQL Server Reporting Services

CD features:

Practice exercises

Database and code samples