Início > Learning > Stairway to Mdx

Stairway to Mdx

http://www.sqlservercentral.com/articles/Stairway+Series/Membes+and+Member+functions+in+MDX/73786/

Multidimensional Expressions (MDX) is a standard query language, derived from SQL but geared specifically for OLAP databases. It also includes a calculation language, with syntax similar to spreadsheet formulas. It is an important skill for PowerPivot. Bill’s new series for MDX starts right at the very beginning and takes us through all the basic functions of MDX, with plenty of practical examples.

Stairway to MDX – Level 1: Getting Started with MDX

To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start.  Read more…
By Bill_Pearson 2011/03/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |   Discuss   Briefcase | 29,909 reads

Stairway to MDX – Level 2: The Ordinal Function

Business Intelligence Architect Bill Pearson introduces the MDX Ordinal Function, as a means for generating lists and for conditionally presenting calculations. He also demonstrates the use of the function in creating datasets to support report parameter picklists.  Read more…
By Bill_Pearson 2011/02/17 | Source: SQLServerCentral.com | Category: mdx
Rating: |   Discuss   Briefcase | 3,006 reads

Stairway to MDX – Level 3: The Order() Function

The Order() function provides the ‘hierarchized’ sorts you need for reports and applications using MDX. In this Step, Business Intelligence Architect Bill Pearson explores using the versatile Order() function for providing dataset sorts that respect dimensional hierarchies.  Read more…
By Bill_Pearson 2011/05/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |   Discuss   Briefcase | 5,130 reads

Stairway to MDX – Level 4: The Order() Function: Beyond Cube Hierarchies

Bill Pearson continues his examination of the versatile Order() function, focusing upon its use in providing dataset sorts that reach beyond dimensional hierarchies  Read more…
By Bill_Pearson 2011/08/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |   Discuss   Briefcase | 2,570 reads

Stairway to MDX – Level 5: Members, and an Introduction to the MDX Members Functions

Bill explains what is meant by a ‘Member’ and ‘Member function’ in MDX. A member is an item in a dimension that include the ‘measures’ which are the values of the attributes that belong to a dimension. ‘Measures’ are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension   Read more…
By Bill_Pearson 2011/09/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |   Discuss   Briefcase | 1,278 reads

Stairway to MDX – Level 6: Member “Family” Functions: .Parent and .Children

Some of the most important ‘Member’ functions of MDX are often known as the ‘Family Functions’. These are used in queries on multidimensional structures for analysis and reporting, and can refer to relative nodes in the hierarchy in much the same way as in a family tree. Read more…
By Bill_Pearson 2011/09/09 | Source: SQLServerCentral.com | Category: stairway series
Rating: |   Discuss   Briefcase | 312 reads

Stairway to MDX – Level 7: Member “Family” Functions: Ancestor() and .FirstChild

BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group, with the Ancestor() and .FirstChild functions.  Read more…
By Bill_Pearson 2011/09/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |   Discuss   Briefcase | 197 reads

Stairway to MDX – Level 8: Member “Family” Functions: .LastChild and .FirstSibling

BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group with the .LastChild and .FirstSibling functions.  Read more…
By Bill_Pearson 2011/10/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |   Discuss   Briefcase | 159 reads

Stairway to MDX – Level 9: Member “Family” Functions: .LastSibling and Cousin()

BI Architect Bill Pearson concludes his introduction to the MDX Members functions. In this Level we wrap up our exploration of the “family” group with the .LastSibling, and Cousin() functions.  Read more…
By Bill_Pearson 2011/10/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |   Discuss   Briefcase | 186 reads
Categorias:Learning
  1. Ainda sem comentários.
  1. No trackbacks yet.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

%d bloggers like this: