[SmartView] How to achieve a retrieval (in excel) that follows exact Outline order ?

Hi,

We have a trickier requirement from users using SmartView. During ad-hoc analysis, the SmartView retrievals for Zoom operations puts the hierarchy in totally REVERSE order of Outline (ancestors like net income to the bottom and the last child next and so on). This is highly confusing to the user community as traditionally they are used to view "Net Income" at the top and the descendants underneath expected to be following the order as could be seen in outline.

Now, the question is how to do a retrieve with ZOOM operation in SmartView that results in retrievals/essbase pull which exactly follows the Outline order