Implementing Business Logic with MDX in Microsoft SQL Server 2000 Course

This course provides delegates with the knowledge and skills necessary to use Multidimensional Expressions (MDX) to add calculated members and other dynamically calculated values to a Microsoft SQL Server 2000 analysis services cube by using SQL Server 2000.

Topics covered on the 3 day Implementing Business Logic with MDX in Microsoft SQL Server 2000 course

OLAP REVIEW

• OLAP databases
• OLAP definitions; warehouse data flow

MDX FOUNDATIONS

• The role of MDX
• MDX member names
• using the calculated member builder
• working with calculated members

USING MDX EXPRESSIONS

• Using MDX expressions
• displaying member information
• displaying family tree relatives
• working with member properties
• using conditional expressions

RETRIEVING VALUES FROM A CUBE

• Understanding multidimensional coordinates
• retrieving a value from a cube
• percent of total calculations
• growth calculations

CREATING SIMPLE MDX QUERIES

• Understanding MDX query statements
• creating simple MDX query statements

CREATING AND MANIPULATING SETS

• Using set creation functions
• using set manipulation functions
• using subquery set functions
• working with dimension interactions

USING AGGREGATION FUNCTIONS

• Understanding aggregation functions
• using time set functions
• calculating a trend

CASE STUDY - IMPLEMENTING BUDGET ALLOCATIONS

• Allocating values from a grand total
• allocating values from a subtotal
• allocating values across multiple dimensions

USING CALCULATED CELLS

• Using calculated cells