|
 Posted 6/27/2008 11:35:28 AM |
| | When 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".
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:
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).
Be sure to save your changes and process the cube. Your records should appear correctly in BI Analytics.
Tony Bell
Product Support
BI Analytics for Dynamics CRM
c360 Solutions
2 Concourse Parkway Suite 800
Atlanta, GA 30328
678.259.8678 Desk
678.274.7789 Cell
tony.bell@c360.com
www.c360.com |
| |
|