|
|
Class Outline*
|
|
| Request Info | Contact Us |
|
Solving Business Problems with MDX in SQL Server 2008
Duration:
3 Days
Overview:
This hands-on, instructor-led course will guide you step-by-step through the Analysis Services 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations, and queries, which will allow users to extract valuable information.
Audience:
This course is intended for
- Anyone who uses Microsoft Analysis Services and want to get a good understanding of MDX
- Anyone who creates OLAP Reports.
- Consultants building OLAP Solutions
- Developers building OLAP Tools
- Controller using cubes and wanting to get more sophisticated information
- MDX users wanting to understand more details
- People upgrading to SQL Server 2008
Prerequisites:
Before attending this course, it is recommended that students have the following skills:
- Basic understanding of Analysis Services.
- The Students should know dimensions, attributes, cubes, hierarchies based on Analysis Services 2005 or 2008.
|
|
Outline:
|
Module 01: Introduction to MDX |
|
- Basic Concepts
- Tuples as Address in Cube
- Sets
- LAB 01A: Using Management Studio to Query Data; Using BI Development Studio to define Calculations
|
|
|
|
Module 02: Basic Queries |
- Basic Query Syntax
- Basic Calculation
- LAB 02A: Basic Queries
- Basic Calculations
- Key difference to SSAS 2000 MDX
- Using Tuples
- LAB 02B: Tuples in Calculations
- Tuples in Sets (Dimensionality)
- Review MDX Syntax
|
|
Module 03: Navigation in Trees |
- Relationships
- LAB 03A: Calculations using Tuples and Relative Tree Navigation
- Conditions using IIF
- Null Handling
- Real World Formulas (Ratios ...)
- Element Name, Uniquename ...
- Review
|
|
Module 04: Sets |
- Introduction
- Set Functions
- Filter (Search for Items, Filter by values,…)
- TopCount / BottomCount (Show top Customers,...)
- Order
- Aggregation (Sum, Min, Max,...)
- Rank
- LAB 04A: Querying Sets
- Real World Examples
- LAB 04B: Real World Queries
- Speed Issues
- LAB 04C: Sets and Execution Speed
- Review
|
|
Module 05: Common Calculations |
- Percent Contributions
- Allocations
- LAB 05A: Allocations
- Averages (simple, weighted, moving)
- Time Based References
- LAB 05B: Time Based References
- Aggregations
- Boundary Condition
- LAB 05C: Aggregations
|
|
Module 06: Reporting Services |
- Introduction
- Limitation for MDX in Reporting Services
- Sub Selects
- Building MDX Based Reports
- Best Practice
- LAB 06A: Queries in Reporting Services
- Parameter Handling
- How To use Parameter / technical details
- depending Parameter
- Practice
- LAB 06B: Parameter Handling in Reporting Services
- Calculations in Reporting Services
|
|
Module 07: Security |
- Introduction
- Roles
- Dynamic Security (based on UserName)
- LAB 07A: Security
|
|
Module 08: KPI |
- Introduction
- Examples
- LAB 08A: Using and Defining KPI
|
|
Module 09: Advanced |
- Date Calculation
- String Operations
- LAB 09A: Date and String Handling
- Visual Totals
- Dynamic MDX (STRTOSET() ,...)
- Solve Order / Calculation Pass
- LAB 09B: Dynamic MDX
- Autoexists
- Nonempty Handling
|
|
Module 10: Cell Calculations |
- Introduction
- Scopes (Session, Query, Cube)
- Real World Solutions
- Planning with Cell Calculations
- LAB 10A: Using Cell Calculations
|
|
Module 11: MDX Scripting |
- Scope / Sub Cube
- Special Aggregations
- LAB 11A: Using MDX Scripting
|
|
Module 12: Optimizing MDX |
|
|
|
Module 13: Client Features |
- Drill Through
- Actions
- Local Cubes
- Writeback
- LAB 13A: Using Client Features
|
|
|
| |
*Content, days, and times vary depending on your location. Please view the outline prior to purchase or contact the local center for more information.
|