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

Configuring the Inventory Monthly Balance Table

This task is a step in the Process of Aggregating Supply Chain Analytics Tables.

You need to configure the parameterfileDW.txt parameters file, and run the initial ETL session or incremental ETL sessions to load the Inventory Monthly Balance table.

To configure the parameterfileDW.txt parameters file

1. Open the parameterfileDW.txt file using Microsoft WordPad or Notepad in the OracleBI\DAC\Informatica\parameters\input folder.
2. Replace the default parameter values with your new values.

   For a list of values for each parameter see the About Configuring the Inventory Monthly Balance Table.

   The default values for the parameterfileDW.txt file are shown in the following table.

   Table 57. Default values in the parameterfileDW.txt file are s

   SESSION	Parameter	Value
   PLP_InventoryMonthlyBalance	$$GRAIN	Month
   PLP_InventoryDailyBalance_Trim	$$KEEP_PERIOD	'MONTH'
   PLP_InventoryDailyBalance_Trim	$$NUM_OF_PERIOD	3

   NOTE:  You need to use single quotes for the values of the KEEP_PERIOD and GRAIN parameters.

3. Save and close the file.

To incrementally refresh the Inventory Monthly Balance table

1. Delete the records from the Monthly Balance (W_INVENTORY_MONTHLY_BAL_F) aggregate table for a certain time.

   The GRAIN parameter determines the time period for the deletion. For example, if GRAIN=MONTH, and the date is May 15, 2005, then all records for April and the current month (May) are deleted in the Monthly Balance (W_INVENTORY_MONTHLY_BAL_F) table.

   Running the PLP_InventoryMonthlyBalance workflow mapping implements this step.

2. Retrieve the records in the Inventory Balance (W_INVENTORY_DAILY_BALANCE_F) fact table and load the records to the Monthly Balance (W_INVENTORY_MONTHLY_BAL_F) table at a certain grain level.

   For example, if GRAIN=MONTH, then the month end balance records in the W_INVENTORY_DAILY_BALANCE_F fact table are stored in and aggregated to the Monthly Balance (W_INVENTORY_MONTHLY_BAL_F).

   Running the S_M_PLP_INV_BALANCE_A1_AGG session, and the M_PLP_INV_BALANCE_A1_AGG mapping implements this step. For the current month balance, balance records of the previous day (if it is in the same month) are deleted from W_INVENTORY_MONTHLY_BAL_F, and balance records of the current day will be loaded from W_INVENTORY_BALANCE_F to W_INVENTORY_MONTHLY_BAL_F.

   Running the PLP_InventoryMonthlyBalance workflow implements this step.

3. Remove the old records from the W_INVENTORY_DAILY_BALANCE_F fact table.

   To remove old records you need to use the KEEP_PERIOD and the NUM_OF_PERIOD parameters. For example, if KEEP_PERIOD=MONTH, NUM_OF_PERIOD=1, and the date is May 15, 2005, then the records for April and the current month (May) are kept and the older records are deleted.

   Running the PLP_InventoryDailyBalance_Trim workflow implements this step.

   NOTE:  The trimming process is to reduce data size in the table. It is important to emphasize that you will not be able to see the old daily balance records. But you will still be able to see the month-end balance. Therefore, please make sure that you adjust the NUM_OF_PERIOD values to reflect your data volume and data recency requirement.