I use pivottable service to query an olap cube (builded with analysis services / SQL server 2K). I would like to sort the member of a dimension in a non-alphabetiq way ...

For example, products A, B and C form the dimension article. By default, the dimension is displayed with the order : A then B then C.
I would like the product B was displayed before the product A : B then A then C.

any idea ??

thank you !