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