cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation files in BPC7.5MS

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

MKEY doesn't work in 7.5M, it's an error in the online documentation.

Former Member
0 Kudos

Thanks! That's what I suspected.

Regards,

Ibai

Answers (0)