MOC-2093 Implementing Business Logic with MDX in Microsoft SQL Server 2000

TEMARIO Y CONTENIDOS

Implementing Business Logic with MDX in Microsoft SQL Server 2000

Course 2093—Three days—Instructor-led

Introduction

This course provides students 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.

At Course Completion

At the end of the course, students will be able to:

•

Understand and use multidimensional terminology.

•

Add calculated members to a cube.

•

Use MDX member functions to navigate within a hierarchy.

•

Use MDX time functions to compare values over time.

•

Use MDX set functions in a query statement.

•

Use functions to manipulate sets of members.

•

Use functions to aggregate values from a set of members.

•

Apply MDX to make a cube change dynamically.

•

Calculate formulas for specific blocks of cells.

•

Control the order of calculations within a cube.

•

Apply MDX in common customer and sales applications.

•

Apply MDX in common financial applications.

Microsoft Certified Professional Exams

This course will help the student prepare for the following Microsoft Certified Professional exam:

•

There are no exams associated with this course.

Prerequisites

Before attending this course, students must have:

•

Successfully completed Course 2074, Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000, or possess equivalent experience.

The course materials, lectures, and activities are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.

Course Materials

The course materials are yours to keep.

You will be provided with the following software for use in the classroom:

•

Microsoft SQL Server 2000

Course Outline

Module 1: OLAP Review

•

OLAP Databases

•

OLAP Definitions

•

Warehouse Data Flow

Module 2: MDX Foundations

•

The Role of MDX

•

MDX Member Names

•

Using the Calculated Member Builder

•

Working with Calculated Members

Module 3: Using MDX Expressions

•

Using MDX Expressions

•

Displaying Member Information

•

Displaying Family Tree Relatives

•

Working with Member Properties

•

Using Conditional Expressions

Module 4: Retrieving Values from a Cube

•

Understanding Multidimensional Coordinates

•

Retrieving a Value from a Cube

•

Percent of Total Calculations

•

Growth Calculations

Module 5: Creating Simple MDX Queries

•

Understanding MDX Query Statements

•

Creating Simple MDX Query Statements

Module 6: Creating and Manipulating Sets

•

Using Set Creation Functions

•

Using Set Manipulation Functions

•

Using Subquery Set Functions

•

Working with Dimension Interactions

Module 7: Using Aggregation Functions

•

Understanding Aggregation Functions

•

Using Time Set Functions

•

Calculating a Trend

Module 8: Case Study - Implementing Budget Allocations

•

Allocating Values from a Grand Total

•

Allocating Values from a Subtotal

•

Allocating Values Across Multiple Dimensions

Module 9: Using Calculated Cells

•

Using Calculated Cells