Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for SAP R/3 >

Configuring the Customer Costs Lines and Product Costs Lines Tables for Siebel Profitability Analytics

This task is a step in the Process of Configuring Siebel Financial Analytics for SAP R/3.

In Siebel Profitability Analytics, the Customer Costs Lines and Product Costs Lines fact tables store the costing and expenses for the Profitability functional area. You need to use these tables with General Ledger Revenue and General Ledger COGS fact tables.

The General Ledger Revenue and General Ledger COGS fact tables are populated by the or SAP R/3 source systems, but the Customer Costs Lines and Product Costs Lines fact tables are populated by the universal source system.

For more information on the Customer Costs Lines and Product Costs Lines fact tables, see About the Customer Costs Lines and Product Costs Lines Tables for Siebel Profitability Analytics.

To load the Customer Costs Lines and Product Costs Lines tables

1. Open the file_cust_costlns.csv file in the $pmserver\srcfiles folder.
2. Insert a record into the file for each customer costing transaction you want to load into the Customer Cost fact table.

   For more information on how to populate each field in the CSV file, please see the Cust_Costlns_Interface_description.xls file.

   For the SOURCE_ID column, you need to provide the same source identifier value as in the file_parameters_sapr3.csv file.

3. Save and close the file.
4. Repeat Step 1 to Step 3 for the file_prod_costlns.csv file.
5. Open Workflow Manager, open the Configuration for Universal Source folder, and run the Universal_Finance_Profitability workflow.

   NOTE:  By default, the Universal_Finance_Profitability workflow loads the Transaction Type dimension and the Customer Costs and Product Costs fact tables. If you need to load other dimensions, open up the Extract_Dimensions and Load_Dimensions worklets and enable the corresponding dimension extract and load sessions.