Siebel Business Analytics Applications Installation and Administration Guide > Customizing the Siebel Data Warehouse > Customization Steps for Siebel Data >

Adding a New Dimension in the Siebel Data Warehouse

• Adding a new custom dimension WC_NEWDIM_D and linking it to W_REVN_F.

Reference:

• SDE and SIL_WaveDimension, SDE and SIL_AssetFact

To add a new dimension and use it with an existing fact table

1. Create a DDL for the new dimension based on the standard structure (with appropriate system columns). Create a staging table for this dimension.
2. Register the new source table (if it does not already exist) in the DAC repository and associate it with the appropriate database connection.
3. Assign it an image suffix if you plan on incrementally loading this table.
4. Create a new custom map SDE_XYZ to populate the dimension stage. Instead of the actual source table (for example S_ABC), use the view that will be generated by the change capture process (for example V_ABC) in the SQL so that it extracts only the incremental data. Use existing reference maps as examples of how to populate the system columns. Make sure you truncate the stage table in corresponding tasks.
5. Create a new custom map SIL_XYZ to populate the new dimension from the stage table. Use the above referenced map as example for how to populate the system columns.
6. Make the following changes to the fact-loading mapping to link the new dimension:

   Do one of the following:

   • Use the extension table's predefined fact table foreign keys that join to this new dimension. (In the above example, the extension table for W_REVN_F must be used to store the foreign key of this new dimension.)
   • Create a new extension table for the fact table with predefined structure to hold a new foreign key, if the foreign keys in existing the extension table have been exhausted.
   • Create new mappings (SDE and SIL) to populate the extension table columns of the fact extension table.
7. Register the new dimension table in the DAC and associate it with the appropriate database connection.

   If you are planning to build a new dimension incrementally, assign an image suffix to the source table. For instructions, see Adding a Column from a Related Source Table in the Siebel Transactional Database.

8. Add the new dimension to all the fact groups that may reference it.
9. Register the workflows as tasks in the DAC.
10. For SDE mapping of the dimension make sure you set the Build Image flag to True, and the Truncate Always option to True. And in the list of source tables, mark the primary/auxiliary source(s) of this dimension.
11. For SIL workflows of the dimension make sure you set only Truncate for Full Load option to True.
12. Make SIL_XYZ depend on SDE_XYZ.
13. Make CustomSIL_RevenueFact depend on load dimension task (SIL_XYZ) and load base fact task (SIL_RevenueFact).