Report Portal

A Better Date Dimension

This requirement has come up a couple of times but I have only just thought of a solution.  How can your date dimension support lots of different calendars (standard January – December Gregorian, fiscal calendars starting in various months, a manufacturing calendar, etc.) without the table getting immensely wide?  And how can you make the calendar in use user-selectable at report run time?

Read more...

 

Tags: design, time

 

2007-2015 VidasSoft Systems Inc.