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

About Configuring the Product Transaction Aggregate Table

There are two aggregation scenarios to configure the Product Transaction aggregate (IA_PROD_XACTS_A1) table—the initial ETL run and then the incremental ETL run.

For your initial ETL run, you need to configure the aggregation level, and the length of history kept in the Product Transaction fact table.

You need to configure three parameters to aggregate the Product Transaction table for you initial run:

• GRAIN
• KEEP_PERIOD
• NUM_OF_PERIOD

For the incremental ETL run, you need to configure the aggregation level, the update period in aggregation, and the length of history kept in the Product Transaction fact table.

You need to configure five parameters to aggregate the Product Transaction aggregate table for you initial run:

• GRAIN
• REFRESH_PERIOD
• NUM_OF_PERIOD (S_M_PLP_PROD_XACTS_A1_AGG)
• KEEP_PERIOD
• NUM_OF_PERIOD (S_M_PLP_PROD_XACTS_TRIM)

The GRAIN parameter has a preconfigured value of Month. The possible values for the GRAIN parameter are:

• DAY
• WEEK
• MONTH
• QUARTER
• YEAR

The REFRESH_PERIOD parameter has a preconfigured value of Month. Values for the REFRESH_PERIOD parameter include:

• DAY
• WEEK
• MONTH
• QUARTER
• YEAR

The KEEP_PERIOD parameter has a preconfigured value of Month. Values for the KEEP_PERIOD parameter include:

• DAY
• WEEK
• MONTH
• QUARTER
• YEAR

The NUM_OF_PERIOD parameter for the S_M_PLP_PROD_XACTS_A1_AGG session has a preconfigured value of 1. The value for the NUM_OF_PERIOD parameter is a positive integer, for example, 1, 2, 3, and so on.

The NUM_OF_PERIOD parameter for the S_M_PLP_PROD_XACTS_TRIM session has a preconfigured value of 3. The value for the NUM_OF_PERIOD parameter is a positive integer, for example, 1, 2, 3, and so on.