Skip Navigation Links

Kursbeschreibung: MOC 2093A

Implementing Business Logic with MDX in SQL Server 2000 (3 Tage)

  • 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

3 Tage


Database developers, database architects, application developers, and business analysts who design, create and/or administer SQL Server 2000 Analysis Services database applications by using SQL Server 2000.

MOC 2074/2259 (Entwerfen und Implementieren von OLAP Lösungen mit Hilfe von SQL Server 2000)

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
Die Schulungsunterlage ist nur auf Englisch verfügbar!
Home | Kontakt | Impressum
©2006 i.d. datenverarbeitung GmbH | Version: 0.0.1