This seminar starts by discussing attribute and dimension relationships. You

will learn how to extend the Unified Dimensional Model (UDM) with KPIs, actions, translations,

and perspectives. And after describing the MDX query fundamentals, the we will

explore MDX calculated members and named sets.

Seminar objectives :

Implement dimensions in a cube.

Configure dimension usage in a cube.

Implement custom logic in a cube by using MDX

Step 1: Defining User Hierarchies and Dimension Relationships

Defining Attribute Relationships

Creating and Modifying User Dimension Hierarchies

Associating Dimensions to Measure Groups

Selecting Relationship Types

Practice: Creating and Modifying Dimension Hierarchies

Step 2: Creating KPIs, Actions, Translations, and Perspectives

Understanding KPI Value, Goal, Status, and Trend Properties

Additional KPI Properties

Creating KPIs

Viewing KPIs

Implementing Actions

Localizing Cubes Through Translations

Implementing Cube Perspectives

Practice: Creating KPIs, Actions, Translations, and Perspectives

Step 3: Creating Calculations and Queries by Using MDX

Understanding MDX Syntax

Applying MDX Functions

Creating Calculated Members

Defining Named Sets

Practice: Extending Cubes by Using MDX Expressions

This seminars series based on Microsoft Certification Training Kit for

Exam 70-448: Microsoft SQL Server 2008 - Business Intelligence Development and

Maintenance

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)