MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1103

Product Units

Thin Fins 434,482

DESC

Product Units

Diet 860,086

Thin Fins 434,482

Silver Scales 425,604

Premium 856,274

Gobi Crab Cakes 223,351

Ancient Mariner 221,871

Neptunes Glory 210,745

Moby Dick 200,745

Standard 834,588

Mako Steak-o 215,521

Gill Thrill 209,962

Anglers Choice 207,662

Briny Deep 201,443

Figure A-30: Hierarchy preserved in ordering.

Also, an extra sophistication in the sorting process is not immediately evident.
Let us imagine that the category-level members [Standard], [Premium], and
[Diet] were not part of the set being queried, while the ProductName mem-
bers still were. Therefore, the category-level [Units] value does not come dir-
ectly into play when the set is ordered. However, when sorting without break-
ing hierarchy, the [Units] value is still calculated at each parent member when