Hi I need to sort the data in multivalue parameter in user defined order, e.g, I have a result like A, B, C, D ...... No wi need to display in the dropdown like C,A,B,D...... which is user requirement How can we achieve this in MDX query resultset, I am using Order() function which will sort in specific order which I dont need. I need to sort in whatever order user has requested. Any replies well appreciated

Where or by what element the sorting order will defined? I imagine a user chooses the desired order somewhere and then gets the result. IMO these kind of requirements are best suited to implement in a specially tailored GUI app that would bring the disconnected results stored locally in initially anyhow ordered manner then offer the end user to drag and drop or re-arrange them, one control I think of that would do that is the grid control.Arthur My Blog

Hello, Can you modify the source table for that dimension? If so, you could add a column to represent the sort order for the data. In SSAS dimension design you can then use this new column for the "SortBy" property to archive this kind of individual sorting.Olaf Helper Blog Xing