Is there any way to get the values in the resulting axis sorted in the same order as in the mdx query?<br>I can arrange the display elements as I wish, and they stay as in the query, but when I open a node and the query contains [x].Children, then all items on all levels<br>
get sorted by their ordinal column/alphabetically. for example<br><br>select {[Time].[2012]} ON COLUMNS,<br> {[Account].[Primary cost], [Account].[BU Overhead], [Account].[Infrastructure Cost Allocation]} ON ROWS<br>from [FI]<br>
<br>when expanding on [BU Overhead] returns an axis with the following Tuples:<br>"[[[Account].[Primary cost]], [[Account].[BU Overhead]], [[Account].[Infrastructure Cost Allocation]], [[Account].[BU Overhead].[BU Overhead]]]"<br>
<br>which gets changed by Hierarchize into:<br>"[[Account].[BU Overhead].[BU Overhead], [Account].[BU Overhead], [Account].[Infrastructure Cost Allocation], [Account].[Primary cost]]"<br><br>which then loses the original ordering when the results are returned.<br>
<br>What I'd be looking for is some way to get it to return<br>"[[[Account].[Primary cost]],[[Account].[BU Overhead]], [[Account].[BU Overhead].[BU Overhead]]], [[Account].[Infrastructure Cost Allocation]] "<br>
or something like that - the point being that the original ordering is retained. Is there any such mechanism... maybe I need to change something in the mdx query?<br>The current query generated is :<br><br>select {[Time].[2012]} ON COLUMNS,<br>
Hierarchize(Union({[Account].[Primary cost], [Account].[BU Overhead], [Account].[Infrastructure Cost Allocation]}, [Account].[BU Overhead].Children)) ON ROWS<br>from [FI]<br><br><br>