|
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Supply Chain Analytics > Process of Aggregating Siebel Supply Chain Analytics Tables >
Configuring the Product Transaction 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 and then the incremental ETL to load the Product Transaction aggregate table. To configure the file_parameters_plp.csv parameters file
- Open the file_parameters_plp.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
- Replace the default PARM_SVALUE2 values with your new values.
For a list of values for each parameter see the About Configuring the Product Transaction Aggregate Table.
The default values are shown in the following table.
|
|
|
|
PLP |
S_M_PLP_PROD_XACTS_TRIM:KEEP_PERIOD |
S |
'YEAR' |
PLP |
S_M_PLP_PROD_XACTS_TRIM:NUM_OF_PERIOD |
S |
3 |
PLP |
S_M_PLP_PROD_XACTS_A1_AGG_INCR:REFRESH_PERIOD |
S |
'MONTH' |
PLP |
S_M_PLP_PROD_XACTS_A1_AGG_INCR:GRAIN |
S |
'MONTH' |
PLP |
S_M_PLP_PROD_XACTS_A1_AGG_INCR:NUM_OF_PERIOD |
S |
1 |
PLP |
S_M_PLP_PROD_XACTS_A1_AGG_INIT:GRAIN |
S |
'MONTH' |
NOTE: You need to use single quotes for the values of the KEEP_PERIOD, GRAIN, and REFRESH_PERIOD parameters. The KEEP_PERIOD value must be equal to or greater than the GRAIN value. The REFRESH_PERIOD value must equal the GRAIN value.
- Save and close the file.
To configure the Product Transaction aggregate table for the initial ETL run
- Retrieve the records in the Product Transaction fact (IA_PROD_XACTS) table, and aggregate the records to the Product Transaction aggregate (IA_PROD_XACTS_A1) table at a certain grain level.
For example, if GRAIN=MONTH then the records in the IA_PROD_XACTS fact table are retrieved and aggregated to the IA_PROD_XACTS_A1 table at a monthly level.
Running the S_M_PLP_PROD_XACTS_A1_AGG_INIT session, and the M_PLP_PROD_XACTS_A1_AGG_INIT mapping implements this step.
- Remove the old records from the IA_PROD_XACTS fact table.
To remove old records you need to use the KEEP_PERIOD and the NUM_OF_PERIOD parameters. For example, if KEEP_PERIOD=YEAR, NUM_OF_PERIOD=3, and the date is May 1, 2005, then the records for the years 2002, 2003, and 2004, and the current year (2005), are kept and the older records are deleted.
Running the S_M_PLP_PROD_XACTS_TRIM session, and the M_PLP_PROD_XACTS_TRIM mapping implements this step.
To configure the Product Transaction aggregate table for the incremental ETL run
- Delete the refreshed records from the Product Transaction aggregate (IA_PROD_XACTS_A1) table for a certain time.
The REFRESH_PERIOD and the NUM_OF_PERIOD parameters determine the time period for the deletion.
For example, if REFRESH_PERIOD=MONTH, NUM_OF_PERIOD=1, and the date is May 15, 2005, then all records for April and the current month (May) are deleted in the IA_PROD_XACTS_A1 table.
Running the S_M_PLP_PROD_XACTS_A1_AGG_INCR session, and the M_PLP_PROD_XACTS_A1_AGG_INCR mapping implements this step.
- Retrieve the records in the Product Transaction fact (IA_PROD_XACTS) table, and aggregate the records to the IA_PROD_XACTS_A1 table at a certain grain level.
For example, if GRAIN=MONTH then the records in the IA_PROD_XACTS fact table are retrieved and aggregated to the IA_PROD_XACTS_A1 table at a monthly level.
Running the S_M_PLP_PROD_XACTS_A1_AGG_INCR session, and the M_PLP_PROD_XACTS_A1_AGG_INCRT mapping implements this step.
- Remove the old records from the IA_PROD_XACTS fact table.
To remove old records you need to use the KEEP_PERIOD and the NUM_OF_PERIOD parameters. For example, if KEEP_PERIOD=YEAR, NUM_OF_PERIOD=3, and the date is May 1, 2005, then the records for the years 2002, 2003, and 2004, and the current year (2005), are kept and the older records are deleted.
Running the S_M_PLP_PROD_XACTS_TRIM session, and the M_PLP_PROD_XACTS_TRIM mapping implements this step.
|
