Sort data in dimension

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

Sort data in dimension

Postby bobibp » Tue Jan 27, 2009 9:36 am

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
bobibp
User
 
Posts: 15
Joined: Sat Jan 10, 2009 7:43 am

Re: Sort data in dimension

Postby AlexZencovich » Sun Feb 22, 2009 6:48 am

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.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 3 guests

cron