During some research on time dimensions in Analysis Services, I stumbled across this interesting article by Dylan Wan (Blog|Linkedin). These are some very good design tips, indeed, but unfortunately, in my case, I had embrace the concept of a supplemental month (might be it has another term in English). A month that is added to the end of a year, in order to keep track of changes made to the year just passed. Changes like these cannot occur in the following year, where they actually occur, but must be tied to the previous year.
I cannot see any way of dealing with this kind of “feature” in a system build on a Julian Date.
Any thoughts on this?