Implementing Business Logic with MDX in Microsoft SQL Server 2000

Code: 2093
Course duration: 3 days
Price:

2093 - Implementing Business Logic with MDX in Microsoft SQL Server 2000
Duration: 3 Days.

Prerequisites:
Before attending this course, students must have:

Course Description:
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

Objectives:

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

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

Course Reviews

No reviews found for this course.

Be the first to write a review