Reading Comments through a csv upload

[former_member593336]

Hello Experts

Can anyone help me how to load comments in SAP BPC 10.1NW through a flat file?

Thanks

Rajani

[chandrakanthk01]

Hi Rajani,

Have you achieved this comments upload via csv flatfile. If yes, could you tell me the steps please?

Thanks,

Chandrakanth.K

[former_member186338 · Accepted solution]

There is no standard way to load comments from text file.

1. Simple - convert text file to Excel with =EPMSaveComment(...

2. Write ABAP program to import directly to table.

Vadim

[former_member593336 · Accepted solution]

Thanks Vadim.

[chandrakanthk01 · Accepted solution]

Hi Vadim,

Could you give me some detailed steps on how to achieve this comments upload via csv flatfile please.

Thanks,

Chandrakanth.K

[former_member186338 · Accepted solution]

chandrakanthk01

Sorry, but have you read my answer?

Did you understand it?

[chandrakanthk01 · Accepted solution]

Yes Vadim,

Simple - convert text file to Excel with =EPMSaveComment(...

As per above statement, I want to know how and where to add that EPM function in the csv file. Appreciate your help.

Thanks,

Chandrakanth.K

[former_member186338 · Accepted solution]

chandrakanthk01

You can use VBA to load txt file into Excel sheet and to insert column with formula =EPMSaveComment(...

What is the issue?

[chandrakanthk01 · Accepted solution]

Yes Vadim,

I am using the CSV file with the heading as Customer which has comments in it and I want that to be loaded using the package. I am not sure how to load them into BPC.

[former_member186338 · Accepted solution]

chandrakanthk01

Sorry, but looks like you don't want to listen to me. I have explained the 2 options clearly. But I will not do your job instead of you!