on 07-22-2010 3:11 PM
I have a transformation file that I am using to load a full year data file. I have one account that I need to flip the sign on. The proper formula is in the conversion file for this account. When I run the package to import the data, the sign only flipped for the first month, not for all 12 months. Obviously, I have an incorrect formula somewhere.
In the Conversion file, my formula is value*-1
In my Transformation file, I have the CONVERTAMOUNTWDIM= specified in the first section
I have Time=*MVAL(3:14) to indicate the 12 months of data in my file in my options
I have Amount=FRCST Conv.xls!frcstacct and TIME=FRCST Conv.xls!frcsttime for the amount formula in the conversion section
I believe the problem is possibly that I don't have amount specified in the options section but I am not sure what formula.
I am sure I am overlooking something simple, any ideas are definitely welcome.
Thank you!
Hi,
Where did you put the formula value*-1? If you put this formula in account conversion file then maintain transformation as follows :
*Options
CONVERTAMOUNTWDIM=c_accnt "Account dimension
CREDITPOSITIVE=NO
*Mapping
Time=*MVAL(3:14)
..
.....
*Conversion
amount=<account conversion file>.xls
c_accnt=<account conversion file>.xls
hope it helps...
regards,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
FORMAT = DELIMITED
HEADER = no
DELIMITER = ,
SKIP = 3
SKIPIF =
VALIDATERECORDS=YES
CONVERTAMOUNTWDIM=ACCOUNT
CREDITPOSITIVE=NO
MAXREJECTCOUNT=10000
ROUNDAMOUNT=
*MAPPING
Account=*col(2)
AcctDetail=*col(2)
Category=*NEWCOL(budget)
DataSrc=*NEWCOL(source)
Entity=*col(1)
Intco=*col(2)
Rptcurrency=*NEWCOL(lc)
Time=*MVAL(3:14)
*CONVERSION
Account=FRCST Conv.xls!frcstacct
AcctDetail=FRCST Conv.xls!frcstacctdetail
Amount=FRCST Conv.xls!frcstacct
Entity=FRCST conv.xls!frcstentity
Intco=FRCST Conv.xls!frcstacctinterco
TIME=FRCST Conv.xls!frcsttime
datasrc=FRCST Conv.xls!frcstds
The above is the set up of my transformation file. I realize I didn't specify this in my first e-mail but the only month that the formula is working for is the first month. The other months are still showing up as negative. I do have the formula in the Account dimension. Is there anything else that I need to specify so the formula applies to all the data being loaded, not just the first month?
Thanks!
Still wondering if there is a way for this formula to work for 12 months vs. 1 month at a time as it is currently doing. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.