Invalid value of 'CURRENCY' whitin dimension member

[NVChaitanya]

Hi Experts,

I am new to BPC trying to upload master data with flat file upload.

When I am processing and validating transformation file currency field is reading data from ID

[NVChaitanya · Accepted solution]

ID           EVDESCRIPTION      CURRENCY

20          NVC, INC, SAN Diego, CA, USA          USD

22          NVC Corporate INC                         USD

23          NVC New Market INC                      USD

25          NVC Ltd, London                              GBP

30          NVC AG ,Germany                                            EUR

Transformation File as

ID=*COL(1)

EVDESCRIPTION=*COL(2)

CURRENCY=*COL(3)

[NVChaitanya · Accepted solution]

Issue got resovled.

EVDECRIPTION has "," (comma) which was causing issue.

When commas are removed data transformation file got validated.

Thanks

[former_member225135 · Accepted solution]

Hi Niranjan,

Please check below link:

Can you also show the structure of currency dimension?

Regards,

Rahul

[former_member186338 · Accepted solution]

Simply save text file with TAB delimiter and use TAB as a delimiter in transformation!

[NVChaitanya · Accepted solution]

Transformation file in option section delimiter was set as , which was causing issue while loading file. When commas are removed from description able to load file without any error.

If file saved as CSV (Comma Delimiter) then in trasformation file option section should be mentioned as "," (Comma) for delimiter

If file is saved as text file with tab limited then in trasformation file option section should be mentioned as TAB for delimiter