Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Aggregating Supply Chain Analytics Tables >

About Configuring the Product Transaction Aggregate Table

There are two aggregation scenarios to configure the Product Transaction aggregate (W_PRODUCT_XACT_A) 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 (PLP_ProductTransactionAggregate)
• KEEP_PERIOD
• NUM_OF_PERIOD (PLP_ProductTransaction_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 PLP_ProductTransactionAggregate 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.

The NUM_OF_PERIOD parameter for the PLP_ProductTransaction_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.