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

Configuring the Inventory Balance Aggregate Table

This task is a step in the Process of Aggregating Siebel Supply Chain Analytics Tables.

You need to configure the file_parameters_plp.csv parameters file, and run the initial ETL session or incremental ETL sessions to load the Inventory Balance aggregate table.

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 Inventory Balance Aggregate Table.

   PARM_TYPE	PARM_CODE	PARM_SVALUE_1	PARM_SVALUE_2
   PLP	S_M_PLP_INV_BALANCE_A1_AGG:GRAIN	S	'MONTH'
   PLP	S_M_PLP_INV_BALANCE_TRIM:KEEP_PERIOD	S	'MONTH'
   PLP	S_M_PLP_INV_BALANCE_TRIM:NUM_OF_PERIOD	S	1

   The default values for the file_parameters_plp.csv file are shown in the following table.

   NOTE:  You need to use single quotes for the values of the KEEP_PERIOD and GRAIN parameters.

3. Save and close the file.

To configure he Inventory Balance aggregate table

1. Delete the records from the Inventory Balance (IA_INV_BALANCE_A1) aggregate table for a certain time.

   The GRAIN parameter determines the time period for the deletion. For example, if GRAIN=MONTH, and the date is May 15, 2005, then all records for April and the current month (May) are deleted in the IA_INV_BALANCE_A1 table.

   Running the S_M_PLP_INV_BALANCE_A1_AGG session, and the M_PLP_INV_BALANCE_A1_AGG mapping implements this step.

2. Retrieve the records in the Inventory Balance (IA_INV_BALANCE) fact table and aggregate the records to the IA_INV_BALANCE_A1 table at a certain grain level.

   For example, if GRAIN=MONTH then the records in the IA_INV_BALANCE fact table are retrieved and aggregated to the IA_INV_BALANCE_A1 table at a monthly level.

   Running the S_M_PLP_INV_BALANCE_A1_AGG session, and the M_PLP_INV_BALANCE_A1_AGG mapping implements this step.

3. Remove the old records from the IA_INV_BALANCE fact table.

   To remove old records you need to use the KEEP_PERIOD and the NUM_OF_PERIOD parameters. For example, if KEEP_PERIOD=MONTH, NUM_OF_PERIOD=1, and the date is May 15, 2005, then the records for April and the current month (May) are kept and the older records are deleted.

   Running the S_M_PLP_INV_BALANCE_TRIM session, and the M_PLP_INV_BALANCE_TRIM mapping implements this step.