Main prob as of 2008 is that all SSAS dimensions are extracted by RS as flat 2d resultsets. If you want to display a hierarchy...
Sorting
can either sort alpha asc or desv on the dimension being displayed OR another hidden dimension. This is the way forward.