0845 757 3888 · info@xpertise.co.uk

On-line training course catalogue

Implementing Business Logic with MDX in Microsoft SQL Server 2000

Type of course: Classroom

Course details
Fee£1025
Days3
Course code MS2093


We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note this course is only available as a closed event.

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.

Prerequisites

Before attending this course, students must have:

or possess equivalent experience.

Delegates will learn how 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 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

Xpertise – Implementing Business Logic with MDX in Microsoft SQL Server 2000 training courses

Xpertise provides Implementing Business Logic with MDX in Microsoft SQL Server 2000 training courses from 22 UK locations: in Aberdeen Scotland, Altrincham Manchester, Birmingham West Midlands, Bristol South West, Edinburgh Scotland, Glasgow Scotland, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), London King William Street, London Middlesex Street, London Rosebery Avenue, London Tabernacle Street, Maidenhead Berkshire, Malmesbury Wiltshire, Manchester (Exchange Quay), Milton Keynes Buckinghamshire, Newcastle Tyne and Wear, Reading Berkshire, Stockport Manchester, Swindon Wiltshire and Washington Tyne and Wear – and at 44 partner locations nationwide.


Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.