few time ago, I had to make a report where the client needed obtain information in order of time's dimension, and specifically the last periods shown in first place.

I achieved it by the MDX form but I think that it could be made in the schema definition.

Thanks for all