Special Character load in BPC 10.1 through Flat File

[former_member419358]

Hello Everyone,

I am working on BPC 10.1 on traditional BW. Currently I am loading Employee master data from Flat Files and employees belong to different countries have their own special characters for name.

When I load master data from flat file to Employee dimension, Data gets loaded successfully but all the special characters are showing incorrectly. Can you please update what to do to load this special characters ?

P.S. If I try to load master data from SAP BW which also has some special characters then system takes care of it because it's coming from SAP BW. I have attached screenshot of Flat file and BPC Dimension for your reference.

Thanks for all your input & feedback in advance.flat-file-employee-master.jpgbpc-employee-1.jpgbpc-employee-2.jpg

[former_member186338]

P.S. Use "Insert Image" instead of "Insert File" - hard to read!

[former_member186338 · Accepted solution]

CSV file is a text file. Before uploading this file to server open it in Notepad. Then "Save As" and select encoding - UTF-8. Then upload it to BPC server.

Sorry for Russian Windows...

[former_member419358 · Accepted solution]

Thanks Vadim. It worked.

[former_member186338 · Accepted solution]

Then please accept this correct answer and close the question!

You have another not closed question, by the way!

[former_member419358]

Hi Vadim,

Thanks for your reply. I am uploading CSV file on BPC server. So, I didn't get your line about checking notepad file.

Regards,

Komik Shah

[former_member186338]

Answer - check encoding of your text file to import (in Notepad).

Save it as UTF-8

[former_member419358]

Hi Vadim,

Sorry the account was created few years ago. I have changed it.

Regards,
Komik

[former_member186338]

Your name "BI NEW" is violating forum rules: https://www.sap.com/community/about/rules-of-engagement.html

Please change it to your real name and I will answer your question!