Kursbeschreibung: MOC 2093A

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

Lernziele:

• 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

Dauer:

3 Tage

Zielgruppe:

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.

Voraussetzungen:

Inhalte:

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!