• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Microsoft SQL Server Training Courses

M2093: Implementing Business Logic with MDX in Microsoft SQL Server 2000

View course dates

Course Duration: 3 days

Course Code: M2093

Course Description:

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:


- Successfully completed course 2074, Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000, or possess equivalent experience.

Prerequisite courses:

M2074: Microsoft SQL Server 2000 Designing and Implementing OLAP Solutions

This course includes the following modules:

OLAP Review

• OLAP Databases
• OLAP Definitions
• Warehouse Data Flow

MDX Foundations

• The Role of MDX
• MDX Member Names
• Using the Calculated Member Builder
• Working with Calculated Members

Using MDX Expressions

• Using MDX Expressions
• Displaying Member Information
• Displaying Family Tree Relatives
• Working with Member Properties
• Using Conditional Expressions

Retrieving Values from a Cube

• Understanding Multidimensional Coordinates
• Retrieving a Value from a Cube
• Percent of Total Calculations
• Growth Calculations

Creating Simple MDX Queries

• Understanding MDX Query Statements
• Creating Simple MDX Query Statements

Creating and Manipulating Sets

• Using Set Creation Functions
• Using Set Manipulation Functions
• Using Subquery Set Functions
• Working with Dimension Interactions

Using Aggregation Functions

• Understanding Aggregation Functions
• Using Time Set Functions
• Calculating a Trend

Case Study - Implementing Budget Allocations

• Allocating Values from a Grand Total
• Allocating Values from a Subtotal
• Allocating Values Across Multiple Dimensions

Using Calculated Cells

• Using Calculated Cells

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course