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