Data in W_INVENTORY_MONTHLY_BAL_F contains only one month's data after ETL. How to load previous month's data e.g 3 months data
Last updated on MARCH 08, 2017
Applies to:Siebel CRM Analytics - Version 7.9.0 [AA 0724] to 22.214.171.124 [Release V7]
Information in this document applies to any platform.
The requirement is to store data for previous months in the the Inventory Monthly Balance Table(W_INVENTORY_MONTHLY_BAL_F).
Below is the configuration made for Inventory Monthly Balance Table in parameterfileDW.txt file:
PLP_InventoryMonthlyBalance $$GRAIN 'MONTH'
PLP_InventoryDailyBalance_Trim $$KEEP_PERIOD 'MONTH'
PLP_InventoryDailyBalance_Trim $$NUM_OF_PERIOD 3
according to the following documentation:
Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users > How to Configure the Inventory Monthly Balance
The current behavior is that, in Oracle Business Intelligence Applications Warehouse, the Inventory Monthly Balance Table(W_INVENTORY_MONTHLY_BAL_F) is populated with one month's data i.e Oct 10, 2008 which corresponds to value in the INV_BALANCE_DT_WID column that is populated with 20081010.
When the report "Inventory Key Metrics" from dashboard Inventory-Overview tab, is run, it shows only one month data i.e October, 2008
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms