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
(Doc ID 752271.1)
Last updated on SEPTEMBER 05, 2019
Applies to:Siebel CRM Analytics - Version 7.9.0 [AA 0724] to 188.8.131.52 [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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document