on 02-21-2011 12:52 PM
Hi Forum,
Has anyone succesfully used the new transformation features in BPC 7.5 Microsoft version? I'm trying to use MKEY, which doesn't validate. I suspect this hasn't been implemented in the Microsoft version. Can anyone confirm?
Error message: Unknown mapping formula: *MKEY
Line: ACCOUNT=MKEY(ACC1|NEWCOL(acc1)||ACC2|*NEWCOL(acc2))
Thanks!
Ibai Madariaga
Hi,
As per the help guide, this keyword is supported. However, I have never tried this. Can you please share the source and the destination template. Just need to know the headings of both the templates.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nilanjan,
Data file looks like this:
dim1,dim2,dim3,acc1,acc2
A,B,C,5,10
E,F,G,20,25
It is required that the transformation will recognise ACC1 and ACC2 as different key figures, as in the example below:
dim1,dim2,dim3,dim4,amount
A,B,C,ACC1,5
A,B,C,ACC2,10
E,F,G,ACC1,20
E,F,G,ACC2,25
The transformation mapping looks like this.
dim1=dim1
dim2=dim2
dim3=dim3
dim4=MKEY(ACC1|NEWCOL(acc1)||ACC2|*NEWCOL(acc2))
The transformation file is syntactically correct except for the line mentioned. I have susccesfully imported data specifying one column.
Thanks,
Ibai
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.