Mdx hierarchical navigation

See http://www.cnblogs.com/downmoon/archive/2011/11/27/2264848.html for details

 

An example of direct kinship access.

Simple

Percentage of the current small class to the parent class.

 

An interesting Function

 
Rank (Tuple_expression,Set_expression[,Numeric expression]) Returns the ranking of the specified tuples in the specified set (the ranking starts from 1 ).
 

. Similar to the SQL window function,

Sort rows

If the sorting isBasc. This is the case if the hierarchy is ignored.

 

Visit distant relatives

 

Ancestor function. Returns a member.

 

Ascendants returns the set of all the ancestor of a member. For example, we want to add a column to calculate the percentage of the bicycle sales to each father.

With

Member measures. percentofthis

([Product]. [product categories]. [product]. [mountain-200 black, 42], [measures]. [reseller sales amount])

/[Measures]. [reseller sales amount]

A very simple calculation column. First, use the domain to calculate a dead value. Then, divide it by the value that will be dispersed by all dimensions without a domain, and you will get the expected value.

 

Descendants function. All member sets with a certain distance of the member are obtained.

Obtain all the classes at the same level as bike.

After obtaining the members of all future generations, the first is the qualifier, the first is an ancestor, the second is a reference object, and the third is the displacement of the reference object.

Functions such as isleaf that are root nodes