Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Strategic Sourcing Analytics > Process of Configuring Siebel Strategic Sourcing Analytics for a Universal Source >

Configuring the Siebel Business Analytics Repository for Siebel Strategic Sourcing Analytics

This task is a step in the Process of Configuring Siebel Strategic Sourcing Analytics for a Universal Source.

Universal source provides the source data for the General Ledger Account (IA_GL_ACCOUNTS) and the Cost Center (IA_COST_CENTER) tables.

The following procedures configure the General Ledger Account and the Cost Center tables for universal source. The second procedure is used to configure a Cost Center for a different General Ledger Account column and when the Cost Center dimension is not populated. You need to identify the correct segment in the General Ledger Account which indicates the cost center information. Siebel Customer-Centric Enterprise Warehouse is preconfigured to use the IA_GL_ACCOUNT.ACCT_SEG2_NAME column as the cost center name and the IA_GL_ACCOUNT.ACCT_SEG2_CODE column as the cost center number.

To configure the repository when the Cost Center dimension is populated

1. Open the SiebelBusinessAnalytics.rpd in the $SAHome\SiebelAnalytics\Repository folder.
2. In the Mapping pane, expand Dim - Cost Centers, and expand Sources.
3. Double-click on DIM_IA_GL_ACCOUNTS_COSTCENTER_SEGMENT, click the General tab, and clear the Active check box.
4. Save the repository.
5. Click Yes to Check Global Consistency, and click OK when the Warnings are displayed.

To configure a Cost Center for a different General Ledger Account column

1. Open the SiebelBusinessAnalytics.rpd in the $SAHome\SiebelAnalytics\Repository folder.
2. In the Mapping pane, expand Dim - Cost Centers, and expand Sources.
3. Double-click on Dim_IA_GL_ACCOUNTS_CostCenter_Segment.
4. In Column Mappings, change the expression column names to the appropriate segment.
5. Double-click on Dim_IA_COST_CENTERS, click the General tab, and clear the Active check box.
6. Save the repository.
7. Click Yes to Check Global Consistency, and click OK when the Warnings are displayed.