Course 2093A:

Implementing Business Logic with MDX in Microsoft SQL Server 2000

Length:3 Days
Published:February 13, 2004
Language(s):English
Audience(s):IT Professionals
Level:100
Technology:Microsoft SQL Server 2000
Type:Course
Delivery Method:Instructor-led (classroom)
About this Course
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.
Course OutlineModule 1: OLAP ReviewLessons
  • OLAP Databases
  • OLAP Definitions
  • Warehouse Data Flow
Module 2: MDX FoundationsLessons
  • The Role of MDX
  • MDX Member Names
  • Using the Calculated Member Builder
  • Working with Calculated Members
Module 3: Using MDX ExpressionsLessons
  • Using MDX Expressions
  • Displaying Member Information
  • Displaying Family Tree Relatives
  • Working with Member Properties
  • Using Conditional Expressions
Module 4: Retrieving Values from a CubeLessons
  • Understanding Multidimensional Coordinates
  • Retrieving a Value from a Cube
  • Percent of Total Calculations
  • Growth Calculations
Module 5: Creating Simple MDX QueriesLessons
  • Understanding MDX Query Statements
  • Creating Simple MDX Query Statements
Module 6: Creating and Manipulating SetsLessons
  • Using Set Creation Functions
  • Using Set Manipulation Functions
  • Using Subquery Set Functions
  • Working with Dimension Interactions
Module 7: Using Aggregation FunctionsLessons
  • Understanding Aggregation Functions
  • Using Time Set Functions
  • Calculating a Trend
Module 8: Case Study - Implementing Budget AllocationsLessons
  • Allocating Values from a Grand Total
  • Allocating Values from a Subtotal
  • Allocating Values Across Multiple Dimensions
Module 9: Using Calculated CellsLessons
  • Using Calculated Cells
Before attending this course, students must have:
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.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Course index

Find Training Near You

Location:
Eg: Seattle, WA or Paris, France

Related Services