Lesson 1: OLAP Review
- OLAP Databases
- OLAP Definitions
- Warehouse Data Flow
Lesson 2: MDX Foundations
- The Role of MDX
- MDX Member Names
- Using the Calculated Member Builder
- Working with Calculated Members
Lesson 3: Using MDX Expressions
- Using MDX Expressions
- Displaying Member Information
- Displaying Family Tree Relatives
- Working with Member Properties
- Using Conditional Expressions
Lesson 4: Retrieving Values from a Cube
- Understanding Multidimensional Coordinates
- Retrieving a Value from a Cube
- Percent of Total Calculations
- Growth Calculations
Lesson 5: Creating Simple MDX Queries
- Understanding MDX Query Statements
- Creating Simple MDX Query Statements
Lesson 6: Creating and Manipulating Sets
- Using Set Creation Functions
- Using Set Manipulation Functions
- Using Subquery Set Functions
- Working with Dimension Interactions
Lesson 7: Using Aggregation Functions
- Understanding Aggregation Functions
- Using Time Set Functions
- Calculating a Trend
Lesson 8: Case Study - Implementing Budget Allocations
- Allocating Values from a Grand Total
- Allocating Values from a Subtotal
- Allocating Values Across Multiple Dimensions
Lesson 9: Using Calculated Cells
|