Implementing Business Logic with MDX in Microsoft SQL Server 2000
(Microsoft Training Course: 2093) - 3 days - £1700 exc VAT

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 an Analysis Services cube by using Microsoft SQL Server 200

Before attending this course, students must have the following pre-requisites:

• Successful completion of course 2074, Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000, or equivalent experience.
  

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