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

To configure the Inventory Balance (IA_INV_BALANCE_A1) aggregate table, you need to consider the aggregation level, the time period to update the aggregation, and the time period to keep records in the Inventory Balance table.

You need to configure three parameters to aggregate the Inventory Balance table:

• GRAIN
• KEEP_PERIOD
• NUM_OF_PERIOD

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

• 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 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.