Visão Geral

Este Curso Microsoft SQL Server Implementing Business Solutions with MDX fornece aos alunos o conhecimento e as habilidades necessárias para usar expressões multidimensionais (MDX) para adicionar membros calculados, conjuntos nomeados e outros valores calculados dinamicamente a um cubo do Microsoft SQL Server Analysis Services.

Materiais

Conteúdo Programatico

Module 1: OLAP Review

1. Understanding the basic elements of online analytical processing (OLAP) databases.
2. Understanding the basic definitions and structures of an OLAP cube.
3. Understanding how data flows through an organization's analytical processes.

Module 2: MDX Foundations

1. Understanding the role of MDX in the overall flow of information through a data warehouse and the two specific functions that it performs.
2. Understand MDX object and member naming conventions.
3. Using the Calculated Member Builder for building simple calculated members
4. Understanding the characteristics of calculated members compared with stored members.

Module 3: Using MDX Expressions

1. Creating MDX expressions in calculated members and manipulating the expressions by using numeric and string constants.
2. Displaying information about a member-particulary the name of the member and the name of the level of the member.
3. Displaying information about the parent or other ancestor of a member.
4. Displaying the member property associated with a member, and using the value in an arithmetic expression.
5. Creating and using simple and complex conditional expressions.

Module 4: Retrieving Values from a Cube

1. Understanding basic concepts of multidimensional coordinates, including how to retrieve values from a cube by specifying a member from a single dimension.
2. Defining a tuple and using tuple expressions to retrieve values with two or more dimensions.
3. Using tuple expressions to retrieve values for calculating percentages of a total.
4. Using tuple expressions to retrieve values for period-to-period growth percentages.

Module 5: Creating Simple MDX Queries

1. Understanding MDX query statement terminology.
2. riting simple MDX query statements.

Module 6: Creating and Manipulating Sets

1. Using functions to create a set.
2. Using functions to manipulate a set.
3. Creating a set from subqueries.
4. Manipulating dimension interactions by using advanced functions.

Module 7: Using Aggregation Functions

1. Creating temporary calculated members.
2. Understanding and creating calculated members from aggregation functions.
3. Understanding and using Time Set Functions.
4. Understanding how to calculate a trend.

Module 8: Case Study - Implementing Budget Allocations

1. Allocating values from a grand total across a dimension.
2. Allocating values from an intermediate level across a dimension.
3. Creating a calculated member that allocates values across three dimensions.

Module 9: Using Subcubes

1. Overwriting cell content via subcubes
2. CALCULATE, SCOPE, IF and FREEZE

Appendix

If time permits, these topics can be practised in a workshop-alike style on the last day of this course:

1. Extending MDX with .Net code
2. MDX Performance tuning