Extending the Date Range in Siebel Analytics

Problem: Date range in Siebel Analytics stopped at year 2010.  We wanted to increase the date range to year 2050.  Please note that the solution mentionned below must be used with caution.  It is advised to test the solution first on a test platform.  Note that the steps mentionned below might need to be modified so that it works in your specific case.  Apply on PROD only if the tests proves successful.

Resolution:

Please test the solution below on a test platform prior to applying on PROD to ensure it works in your case.

Siebel Analytics Version: 7.9.2


1. Open DAC

2. Go to Design -> Task -> Query on “SIL_DayDimension” ->Parameters

3. Set the $$END_DATE parameter of SIL_DayDimension task to the required value.

4. Save changes.

5. Source file FISCAL_MONTHS: need to be amended manually to include extended date range

6. Go to Design -> Source System Parameters -> $$ANALYSIS_END/ $$ANALYSIS_END_WID ( Modify Parameters $$ANALYSIS_END and $$ANALYSIS_END_WID to the required values

7. Set the refresh date to NULL for the following tables (Setup --> Physical Data Sources --> Datawarehouse -->Refresh Dates):

a. W_DAY_D --

b. W_WEEK_D

c. W_MONTH_D

d. W_QTR_D

e. W_YEAR_D

f. W_DUAL_G —

g. w_day_d_fscl_mnth_tmp --

h. w_day_d_fscl_per_tmp --

i. w_day_d_fscl_tmp --

8. Back up tables W_DUAL_G, W_DAY_D, W_MONTH_D, w_day_d_fscl_mnth_tmp, w_day_d_fscl_per_tmp, w_day_d_fscl_tmp

9. Truncate tables W_DUAL_G, W_DAY_D, w_day_d_fscl_mnth_tmp, w_day_d_fscl_per_tmp, w_day_d_fscl_tmp

10. Insert row with row_wid 19800101 from BACKED_UP W_DAY_D as same doesnot seem to be populated by the mapping.
11. Run an incremental load of your typical execution plan

12. Check if W_MONTH_D has been properly extended.  If not, truncate W_MONTH_D

13. Manually run SIL_MonthDimension

The above steps should normally do it.  It did it in our case. All the best.