I have a report based on Bex query and Query it self has a prompt.when it is executed on bex analyzer as it seen below , prompt values appears sorted,
But it's not the case in webi or in any BO tool, It's not sorted and there is no way to sort in prompt panel.
Users want to see it in order, and really insist on it! :S
thanks in advance..