Implementing Business Logic with MDX in Microsoft SQL Server 2000

Code: 2093
Course duration: 3 days

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

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


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

Guaranteed to Run

2019-08-28 09:00 to 2019-08-30 17:00
Attend Online
2019-08-14 09:00 to 2019-08-16 17:00
Attend Online
09:00 to 17:00
Fort Lauderdale, Florida (Instructor-Led)
2019-08-07 09:00 to 2019-08-09 17:00
Attend Online
09:00 to 17:00
Palm Beach County Florida (Instructor-Led)
2019-07-25 09:00 to 2019-07-26 17:00
NYC-23rd Street (Virtual Instructor-Led)
2019-07-25 09:00 to 2019-07-26 17:00
Attend Online
2019-07-24 09:00 to 2019-07-26 17:00
Washington, D.C. (Virtual Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review