Implementing Business Logic with MDX in Microsoft SQL Server 2000

QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

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:

Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000
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 ...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

TEL: 0844 871 2080
E-mail us: info@qa.com

Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,

Search other schools for Implementing Business Logic with MDX in Microsoft SQL Server 2000 training resources.

Deploying and Managing Microsoft System Center Virtual Machine Manager
Planning, Deploying and Managing Microsoft System Center Configuration Manager 2007
Microsoft Silverlight 2
Microsoft Silverlight 1.0 for Designers
Network Solution for the Small and Medium Sized Business
Windows Small Business Server 2008
Microsoft SoftGrid Application Virtualization
Administering a Microsoft SQL Server 2000 Database
Microsoft SQL Server 2000 Reporting Services
Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000
Implementing Replication Using Microsoft SQL Server 2000
Microsoft SQL Server 2000 Data Transformation Services
Querying Microsoft SQL Server 2000 with Transact-SQL
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Designing a Microsoft SQL Server 2005 Infrastructure
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.