Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Strategic Sourcing Analytics > Process of Configuring Siebel Strategic Sourcing Analytics for Oracle 11i >

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 Oracle 11i.

A General Ledger account can contain cost center information. However, the Cost Center dimension table is not loaded for Oracle 11i.

The department segment of the General Ledger account is commonly used as a cost center. You can map this segment as a cost center in the Siebel Business Analytics Repository. 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 for Siebel Strategic Sourcing Analytics for Oracle 11i

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.
6. Click the General tab and clear the Active check box.
7. Save the repository.
8. Click Yes to Check Global Consistency, and click OK when the Warnings are displayed.