Skip to Content
0
Former Member
Jan 19, 2012 at 10:13 AM

Import Works but doesn't Update Members

37 Views

Hi

I think we have a problem with a transformation/conversion file setup or possibly a problem with the data file which is being uploaded.

Here is the transformation file:

*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER =
SKIP = 0
SKIPIF = 
VALIDATERECORDS=YES
CREDITPOSITIVE=NO
MAXREJECTCOUNT=-1
ROUNDAMOUNT=
NULLAMOUNTVALUE=0

*MAPPING
TIME=*MVAL(10:13)
OHCOSTCENTRE=*COL(1)
ACCOH=*COL(2)
RPTCURRENCY=*COL(8)
DATASRC=*COL(5)
CATEGORY=*COL(4)
BRAND=*COL(3)
PROJECT=*COL(7)
OPTIONAL3=*COL(6)
MEASURES=*COL(9)

*CONVERSION
TIME=TIMEPIUK.XLS

Here is the conversion file:

EXTERNAL	INTERNAL	FORMULA
P1-11	2011.P01	
P2-11	2011.P02	
P3-11	2011.P03	
P4-11	2011.P04	
P5-11	2011.P05	
P6-11	2011.P06	
P7-11	2011.P07	
P8-11	2011.P08	
P9-11	2011.P09	
P10-11	2011.P10	
P11-11	2011.P11	
P12-11	2011.P12	
P1-12	2012.P01	
P2-12	2012.P02	
P3-12	2012.P03	
P4-12	2012.P04	
P5-12	2012.P05	
P6-12	2012.P06	
P7-12	2012.P07	
P8-12	2012.P08	
P9-12	2012.P09	
P10-12	2012.P10	
P11-12	2012.P11	
P12-12	2012.P12	

...and here is the data file:

Ohcostcentre,Accoh,Brand,Category,Datasrc,Optional3,Project,Rptcurrency,Measures,P9-11,P10-11,P11-11,P12-11
202175090,5000002150,0000,SD4,INPUT,00000000,000000,LC,Periodic,1,2,3,4
202121132,5005002130,0000,SD4,INPUT,00000000,000000,LC,Periodic,1,2,3,4

On running import the data appears to have been uploaded i.e. 8 records imported and no rejections but when I then check the EVDRE report none of the members have been updated with these values. I've checked and all the members that I'm writing to are valid in the cube as well.

Has anyone else experienced this? If so how can I go about resolving this issue?

Thanks,

Jamie