c360 Forums / Version 4 Products Questions / BI Analytics / Other Products / Why don't I see records past 2003 in my reports? / Latest PostsInstantForum.NET v4.1.4c360 Forumshttp://www.c360.com/Forums/support@c360.comFri, 21 Nov 2008 07:58:52 GMT20Why don't I see records past 2003 in my reports?http://www.c360.com/Forums/Topic2068-82-1.aspxWhen BI Analytics is installed, the default cube that is built only has dates between 1/1/2003 and 12/31/2006. As a result, any records in your CRM system past 12/31/2006 will not be associated with the time dimension in BI Analytics. Those records will appear under "Not Specified".<BR><BR>In order to have them appear correctly, it will be necessary to modify the time dimension in the cube. To do this, simply open the Analysis Server database in SQL Server Business Development Studio (BIDS) and double click on the time dimension. It will look like this:<BR><BR><IMG alt=Image src="http://www.s2kaccessories.com/pics/SCC/2008-05-19_073517_web.jpg"><BR><BR>Notice the CalendarStartDate and CalendarEndDate entries. To make the change, simply click in the CalendarEndDate box and change the end date for the time dimension (see picture below).<BR><BR><IMG alt=Image src="http://www.s2kaccessories.com/pics/SCC/2008-05-19_074028_web.jpg"><BR><BR>Be sure to save your changes and process the cube. Your records should appear correctly in BI Analytics.Fri, 27 Jun 2008 11:35:28 GMTTony Bell