Bookshelf v7.8.3: About the Initialization Workflow

Running the common initialization workflow, INITIALIZE, verifies that both the PowerCenter and the Siebel Customer-Centric Enterprise Warehouse are installed successfully. Running the INITIALIZE workflow also initializes the dimension tables, and verifies that your date tables are configured correctly.

The common initialization workflow must be run only once, but it is run before any of the other workflows. The INITIALIZE workflow contains prepackaged files that are required by your system, regardless of your source type, to use the Siebel Business Analytics installation.

The common initialization workflow contains four worklets and one stand-alone workflow:

These worklets, nested within the initialization workflows, write results to the target tables specified in Table 9. A worklet is an object that represents a set of tasks. It allows you to reuse a set of workflow instructions in several workflows. Table 9 lists the common initialization worklets and the target tables.

Table 9. Common Initialization Worklets and Target Tables
Workflow or Worklet Name	Task Name	Target Table Name
Z_INITIAL	S_M_Z_INITIAL_LOAD_1	IA_DATES
		IA_CAL_MONTHS
		IA_CAL_WEEKS
		IA_CAL_QTRS
		IA_CAL_YEARS
		IA_FSC_MONTHS
		IA_FSC_WEEKS
		IA_FSC_QTRS
		IA_FSC_YEARS
Z_LOAD_DATES_TIME	S_M_Z_TIME_OF_DAY_LOAD	IA_TIME_OF_DAY
	S_M_Z_TIME_OF_DAY_AGGR	IA_HOUR_OF_DAY
	S_M_Z_DATES_LOAD	IA_DATES
Z_LOAD_DATES_AGGR	S_M_Z_DATES_AGGR	IA_CAL_MONTHS
		IA_CAL_WEEKS
		IA_CAL_QTRS
		IA_CAL_YEARS
	S_M_Z_DATES_FSC_AGGR	IA_FSC_MONTHS
		IA_FSC_WEEKS
		IA_FSC_QTRS
		IA_FSC_YEARS
	S_M_Z_DATES_FSC_AGGR	IA_DATES
	S_M_Z_SYSDATE_CREATION	TZ_DATES_GENERIC
Z_LOAD_DATES	SIL_DayDimension	W_DAY_D
	SIL_DayDimension_GenerateRow1	W_DUAL_G
	SIL_DayDimension_GenerateRow2	W_DUAL_G
	SIL_DayDimension_GenerateRow3	W_DUAL_G
	SIL_DayDimension_GenerateRow4	W_DUAL_G
	SIL_DayDimension_GenerateRow5	W_DUAL_G
	SIL_DayDimension_GenerateRow6	W_DUAL_G
	SIL_DayDimension_GenerateRow7	W_DUAL_G
	SIL_DayDimension_GenerateSeed	W_DUAL_G
	SIL_DayDimension_Unspecified	W_DAY_D
	SIL_FiscalMonthDimension	W_FSC_MONTH_D
	SIL_FiscalWeekDimension	W_FSC_WEEK_D
	SIL_MonthDimension	W_MONTH_D
	SIL_QuarterDimension	W_QTR_D
	SIL_WeekDimension	W_WEEK_D
	SIL_FiscalQuarterDimension	W_FSC_QTR_D
	SIL_FiscalYearDimension	W_FSC_YEAR_D
	SIL_YearDimension	W_YEAR_D
	SIL_DayDimension_CleanSeed	W_DUAL_G