Chinaunix首页 | 论坛 | 博客
  • 博客访问: 286376
  • 博文数量: 62
  • 博客积分: 2966
  • 博客等级: 少校
  • 技术积分: 615
  • 用 户 组: 普通用户
  • 注册时间: 2007-06-07 23:16
个人简介

Be a simple man

文章分类

全部博文(62)

文章存档

2012年(6)

2011年(15)

2010年(6)

2009年(3)

2008年(5)

2007年(27)

我的朋友

分类:

2010-02-04 10:48:44

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
 
 
阅读(614) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~