Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > About Resolving Dimension Keys >

Configuring the Dimension Key ID

There are many ways in which you can configure Dimension Key IDs. This section provides procedures on configuring dimension keys so that your dimension tables load data at an appropriate granular level and, also so that your keys get resolved.

Each Dimension Key ID has a default value, which you can configure. If you want to reset the value of a Dimension Key ID, you must modify the Key ID definition in the dimension extract mapping, in the Expression transformation, as well as in every fact load that uses the key. For example, if you want to modify the Key ID for the IA_GL_ACCOUNTS dimension table, then you must modify the Key ID's definition in the IA_GL_ACCOUNTS extract mapping's Expression transformation.

In addition, you have to modify any fact table load mapping that uses the key. For example, because the IA_SALES_IVCLNS fact table uses the Key ID of the IA_GL_ACCOUNTS dimension table, you must modify the Key ID definition in the IA_SALES_IVCLNS load mapping's Source Adapter mapplet. The following two procedures tell you how to accomplish both of these tasks.

To configure the Key ID in the dimension extract mapping

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. Open the applicable extract mapping.
3. Double-click the Expression transformation to open the Edit Transformations box.
4. Edit the expression for the KEY_ID column.

   For example, if you redefine the KEY_ID column for the IA_GL_ACCOUNTS table, modify the default Key ID port in the M_I_GL_ACCOUNTS_EXTRACT mapping, which, by default, is set to the Set-of-Books ID ~ Code Combination ID (TO_CHAR(SOB_ID)||'~'||TO_CHAR(CC_ID)). You can reset the grain of this dimension table by setting the Key ID to something else, like Set-of-Books ID ~ GL account number.

   NOTE:  Verify that any modified Key ID continues to uniquely identify each record in the table.

5. Validate and save your changes to the repository.

To configure the Key ID in the fact load mapping

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. Open the applicable fact mapping's Source Adapter mapplet.
3. Double-click the Expression transformation to open the Edit Transformations box.
4. Edit the expression for the *_ID column.

   For example, if you want to redefine the IA_GL_ACCOUNTS Key ID in the IA_SALES_IVCLNS table, modify the default Key ID as shown in the following:

   TO_CHAR(INP_SETS_OF_BOOK_ID)||'~'||

   TO_CHAR(INP_CODE_COMBINATION_ID)

5. Validate and save your changes to the repository.
6. Repeat these steps for every fact table that is joined to the dimension in question.