Business Solutions with MDX

—Introduction 3m 5s
—Business Need: Return All Members 2m 58s
—Business Solution: Return All Members 2m 29s
—Business Need: Manage 'Divide by Zero' 2m 37s
—Business Solution #1: Manage 'Divide by Zero' 3m 49s
—Business Solution #2: Manage 'Divide by Zero' 2m 15s
—Business Need: Restrict Output to Associated Members 3m 54s
—Business Solution: Restrict Output to Associated Members 3m 56s
—Business Need: Calculate Contribution to Parent 1m 45s
—Business Solution - Step #1: Calculate Contribution to Parent 4m 25s
—Business Solution - Step #2: Calculate Contribution to Parent 3m 15s
—Business Solution - Step #3: Calculate Contribution to Parent 3m 31s
—Conclusion and Summary 1m 39s

—Introduction 2m 0s
—Business Need: Best Performers - and Everyone Else 3m 13s
—Business Solution Pt. 1: Best Performers - and Everyone Else 2m 58s
—Business Solution Pt. 2: Best Performers - and Everyone Else 2m 35s
—Business Need and Initial Solution: Extract and Present a Tuple 4m 53s
—Business Solution Pt. 2: Extract and Present a Tuple 4m 17s
—Business Need: Restrict Set Membership via Filtering 1m 41s
—Business Solution: Restrict Set Membership via Filtering 4m 21s
—Business Need: Exclude Set Members via Except() 1m 40s
—Business Solution Pt. 1: Exclude Set Members via Except() 2m 26s
—Business Solution Pt. 2: Exclude Set Members via Except() 1m 55s
—Business Need: Set Sophistication with Extract() 1m 46s
—Business Solution: Set Sophistication with Extract() 4m 6s
—Business Need: Set Sophistication with Generate() 1m 55s
—Business Solution Pt. 1: Set Sophistication with Generate() 2m 6s
—Business Solution Pt. 2: Set Sophistication with Generate() 2m 38s
—Conclusion and Summary 2m 16s

—Introduction 1m 59s
—Business Need: To-date Accretions 5m 3s
—Business Solution Pt. 1: To-date Accretions 5m 36s
—Business Solution Pt. 2: To-date Accretions 5m 20s
—Business Need: Compound Date-based Calculations 3m 5s
—Business Solution: Compound Date-based Calculations 5m 29s
—Business Need: Moving Averages to Smooth Values Over Time 1m 50s
—Business Solution: Moving Averages to Smooth Values Over Time 3m 37s
—Business Need: Last Dates Concepts 1m 57s
—Business Solution Pt. 1: Last Dates Concepts 5m 2s
—Business Solution Pt. 2: Last Dates Concepts 6m 26s
—Business Solution Pt. 3: Last Dates Concepts 3m 39s
—Business Need: Deliver the Current Date 2m 0s
—Business Solution Pt. 1: Deliver the Current Date 6m 1s
—Business Solution Pt. 2: Deliver the Current Date 3m 40s
—Conclusion and Summary 1m 59s

—Introduction 2m 19s
—Business Need: Retrieve Basic Dimension, Level, and Hierarchy Information 1m 8s
—Business Solution Pt. 1: Retrieve Basic Dimension, Level, and Hierarchy Information 5m 25s
—Business Solution Pt. 2: Retrieve Basic Dimension, Level, and Hierarchy Information 3m 48s
—Business Need: Horizontal Navigation 2m 10s
—Business Solution Pt. 1: Horizontal Navigation 5m 43s
—Business Solution Pt. 2: Horizontal Navigation 3m 47s
—Business Need: Vertical Navigation - Nuclear Family 2m 45s
—Business Solution Pt. 1: Vertical Navigation - Nuclear Family 1m 43s
—Business Solution Pt. 2: Vertical Navigation - Nuclear Family 4m 10s
—Business Need: Vertical Navigation - Extended Family 2m 4s
—Business Solution Pt. 1: Vertical Navigation - Extended Family 3m 15s
—Business Solution Pt. 2: Vertical Navigation - Extended Family 6m 4s
—Business Solution Pt. 3: Vertical Navigation - Extended Family 3m 48s
—Business Solution Pt. 4: Vertical Navigation - Extended Family 4m 32s
—Business Solution Pt. 5: Vertical Navigation - Extended Family 3m 4s
—Conclusion and Summary 2m 18s

—Introduction 2m 34s
—Business Need: Perform Basic Allocation Using MDX 2m 43s
—Business Solution Pt. 1: Perform Weighted Allocations 4m 0s
—Business Solution Pt. 2: Perform Weighted Allocations 4m 45s
—Business Solution Pt. 3: Perform Unweighted Allocations 4m 43s
—Business Need: Perform ABC Classification 4m 36s
—Business Solution Pt. 1: Perform ABC Classification 4m 25s
—Business Solution Pt. 2: Perform ABC Classification 5m 7s
—Business Solution Pt. 3: Perform ABC Validation 4m 15s
—Business Solution Pt. 4: Perform ABC Parameterization 5m 26s
—Conclusion and Summary 1m 33s

—Introduction 0m 45s
—Business Need: MDX Analysis in Action 4m 12s
—Business Solution Pt. 1: MDX Analysis in Action 3m 32s
—Business Solution Pt. 2: MDX Analysis in Action 5m 28s
—Business Solution Pt. 3: MDX Analysis in Action 3m 22s
—Business Solution Pt. 4: MDX Analysis in Action 4m 48s
—Business Solution Pt. 5: MDX Analysis in Action 2m 49s
—Business Solution Pt. 6: MDX Analysis in Action 5m 20s
—Business Solution Pt. 7: MDX Analysis in Action 2m 13s
—Business Need Pt. 1: Key Performance Indicators 4m 58s
—Business Need Pt. 2: Key Performance Indicators 2m 41s
—Business Solution Pt. 1: Key Performance Indicators 4m 46s
—Business Solution Pt. 2: Key Performance Indicators 6m 6s
—Business Solution Pt. 3: Key Performance Indicators 2m 24s
—Business Solution Pt. 1: Use MDX to Query KPI 4m 3s
—Business Solution Pt. 2: Use MDX to Query KPI 2m 13s
—Conclusion and Summary 1m 34s