Sort data in dimension

[bobibp]

One of my dimensions is a DATE. I want to sort it as a date not as a string. My shortdatetime format is 'DD.MM.YYYY'
Now it's sorting like this:
01.11.2008
01.12.2008
02.11.2008

the right way should be:
01.11.2008
02.11.2008
01.12.2008

Thank you

[AlexZencovich]

Please use sort by Key instead of sort by Name (see in dimension editor). You have to also set it as default sorting method in TPivotCube.Dimensions configuration before cube built.