Conversion file not working - Invalid value of 'RATETYPE' within dimension member

[Former Member]

Hi all, I have a transformation file which is driving me crazy because it doesn't seem to be going through the conversion file I specify. Namely I want to import master data from BW and use conversion files for assigning the RATETYPE property of accounts.

The conversion file is working for the ID property, however for RATETYPE it's not taking the values specified in the EXTERNAL column.

My transformation file with reference to a conversion file for ID and RATETYPE:

My conversion file CONVERSION_MD_BW, the CUENTA_ID sheet which removes the leading zeroes from accounts. This one is working correctly:

My conversion file CONVERSION_MD_BW, the CUENTA_RATETYPE sheet which assigns constant value of AVG to all accounts (only for testing that it's working, the actual logic is 1* = CLO, 2*= LEQ,...):

I'm getting the following error message:

Task name CONVERT:


No 1 Round:
Master data (dealt by table level) has errors
Invalid value of 'RATETYPE' within dimension member 18006
Invalid value of 'RATETYPE' within dimension member 100000
Invalid value of 'RATETYPE' within dimension member 100001
Invalid value of 'RATETYPE' within dimension member 100002
Invalid value of 'RATETYPE' within dimension member 100003
Invalid value of 'RATETYPE' within dimension member 100004
Invalid value of 'RATETYPE' within dimension member 100005

Any hint why the conversion file is working for the ID and not for RATETYPE?? Any feedback appreciated thanks in advance!

[former_member186338 · Accepted solution]

Try in transformation:

RATETYPE=*NEWCOL(AVG)

and without conversion for RATETYPE

What will be the result?

Vadim

[Former Member · Accepted solution]

Hi vadim, that works but as expected it assigns constant value of AVG. How could I include a conversion based on account ID for assigning RATETYPE? thanks

[former_member186338 · Accepted solution]

Ups, it's because of CONVERT_INTERNAL=YES Set it as recommended to NO and continue!

[Former Member · Accepted solution]

Great Vadim thanks to your hint it's now working!

I didn't know the following

CONVERT_INTERNAL = YES | NO

This option compares input member names with columns in the conversion file. If NO, the input member names are compared with the external column in conversion file. If YES, the input member names are compared with the internal column in conversion file.

So I needed to switch "* AVG" for "AVG *" and CONVERT_INTERNAL = YES to be able to use Javascript in EXTERNAL, great feedback as always my compliments.