IP Scenario:
Current Cube Data
Version Material Customer Forecast
20 12345 AAA 100
60 12345 AAA 100
Cube Data wanna
Version Material Customer Forecast
20 12345 AAA 50
60 12345 AAA 100
Pls notes that if we load data as following:
New Upload File only contains data for Version=20
Version Material Customer Forecast
20 12345 AAA 50
the Version=60 record is deleted because it was not in the Upload File.
Solution:
Load file into temporary version (lets say 999) and then in FOX formula copy data to needed version.
In upload process define 2 fileds for versions: temp and real version.
Upload to IP and then copy to real version.
Reason:
In standard copy function records that not exist in source but exist in target will be deleted
阅读(606) | 评论(0) | 转发(0) |
