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

To configure the Inventory Monthly Balance (W_INVENTORY_DAILY_BALANCE_F_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 configure the Inventory Monthly 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.