Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Sales Analytics > Process of Aggregating Siebel Enterprise Sales Analytics Tables >

Configuring the Sales Order Lines Aggregate Table

This task is a step in the Process of Aggregating Siebel Enterprise Sales Analytics Tables.

To load the Sales Order Lines aggregate table (IA_SLS_ORDLNS_A1), you need to configure the post-load-processing parameter file and the source system parameter files, and run the initial and then the incremental workflows.

To configure the file_parameters_plp.csv parameters file

1. Open the file_parameters_plp.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Sales Order Lines Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_PLP_SLS_IVCLNS_A1_AGG_INIT:GRAIN session value.

3. Save and close the file.

To configure the Sales Order Lines aggregate table for Oracle 11i

1. Open the file_parameters_ora11i.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Sales Order Lines Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_I_SALES_ORDLNS_PRE_D:SOURCE_ID and S_M_I_SALES_ORDLNS_PRE_U:SOURCE_ID session values.

3. Save and close the file.

To configure the Sales Order Lines aggregate table for SAP R/3

1. Open the file_parameters_sapr3.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Sales Order Lines Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_S_SALES_ORDLNS_PRE_D:SOURCE_ID and S_M_S_SALES_ORDLNS_PRE_U:SOURCE_ID session values.

3. Save and close the file.

To configure the Sales Order Lines aggregate table for Universal Source

1. Open the file_parameters_univ.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Sales Order Lines Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_F_SALES_ORDLNS_PRE_U:SOURCE_ID session value.

3. Save and close the file.