fbpx

Order (MDX)

Orders members in a set optionally keeping their natural order (i.e., hierarchical order).

Parameters

Name Type Cardinality Default value
set  set-expression  one   
number  numeric-expression  zero-one   
option  ASC|DESC|BASC|BDESC  zero-one  ASC 

Return

set

Description

The function performs a rearrangement of the specified set. It is possible to break the hierarchy ordering during members arrangement using additional flag option.

1) If BASC or BDESC is specified: members are ordered regardless of their natural position. Parent/child relations are broken.

2) If ASC or DESC flag is specified: only sibling members (children of the same parent) are ordered. So, parent/child relations are kept in the resulting set.

The ASC flag is the default option.

Examples

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.