OLAP Time dimension does not contain dates for year 2011

I ran into this problem when running TS_DeliveryPerformance report which was simply empty. After investigation I saw that all packing slip transactions made in January 2011 were shown in Sales Cube under Unknown year. Going forward when I browse Time dimension I could see that dates are only generated till the end of 2010 year.  I tried to process it several times but it did not change anything. The problem with Time dimension was that property Source - CalendarEndDate was set up to 12/30/2010 4:00 PM what was the reason the dates were not getting generated. After changing property to 12/30/2020 4:00 PM and processing dimension the date for 2011 was shown. Of course you can think on every other date than 30 Dec 2012 as performance of processing this dimension depend on how many dates it has to create from CalendarStartDate till CalendarEndDate


--author: Czesława Langowska
--editor: Czesława Langowska
--date: 07-01-2011
Comments (2)

  1. Tommy Skaue says:


    Thank you for sharing!

    I published a screencast showing how to fix this here: screencast.com/…/OZLgAaIs

  2. Art Olsen says:

    Thanks Czesława . This resolved the same issue for me very easily.

Skip to main content