Behavior of WraTo

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

Moderator: Alex Zencovich

Behavior of WraTo

Postby warmbooter » Thu May 27, 2010 12:06 pm

I usually use the WrapTo property of a dimension to show dates totals grouped by month. This works very well if all the dates are inside the same year, but if the time range involves two or more years, I cannot distinguish the month of one year with the same month of the other year, since the cube join them as a single month.

Same problem if I use Quarter instead of month.

Is there a way to make the cube to use the year info and not group months/quarters of one year with another year?
warmbooter
Guest
 
Posts: 4
Joined: Thu Apr 19, 2007 12:21 am

Re: Behavior of WraTo

Postby AlexZencovich » Fri May 28, 2010 10:35 am

If you setup 2 dimensions year and month and place them one inside other year->month all data will be grouped correctly.
Another way, make a custom wrapping for Month Of The Year value like
key = (Month shr 8) or (Year - 2000)
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 6 guests

cron