cancel
Showing results for 
Search instead for 
Did you mean: 

How to load comments from Flat file to BPC

former_member398742
Participant
0 Kudos

Hi Everyone,

I have a requirement to load comments from Flat file to BPC.

Can you please suggest me how can I achieve this?


Regards,

Vishu

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member222556
Contributor
0 Kudos

Try to use simple ABAP code to write the comment directly in the ABAP table from excel File.

Excel Upload to ABAP table.

it should work

former_member186338
Active Contributor
0 Kudos

Hi Vishu,

You have 2 options:

1. Generate Excel table from your text file with EPMSaveComment functions

2. Write a badi to store comments in the comments table.

Vadim

P.S. Just search forum - a lot of info about comments copy/upload

P.P.S. To find the comments table name use UJ0_GET_GEN_TABNAME in SE38

former_member398742
Participant
0 Kudos

Thanks Vadim for replay.

I just want to explain my scenario why i am loading comments from flat file to BPC.


We are filling some data in Web ,that needs to load in to BPC.

Let say I have two fields in web based. Employee, Project, working hours , Notes.

First I am preparing Csv file by excluding Notes/comments as i cant load them though DM Package.


I have one idea based on your comments. I just want to confirm with you whether it will work or not.

    1. First i will load data to BPC from Flat file which i downloaded data from web (Here excluded comments)


   2. I can create report for last week data as i am loading weekly basis.

   3. I will add all the comments in the report which i excluded from Csv file

   4. Finally i can use EPMSavecomment function


Can you pls let me know whether this solution will work as i expected.


-Vishu



former_member186338
Active Contributor
0 Kudos

Yes, you can write some simple VBA code to process the text file with comments and related members to create an Exel sheet with multiple EPMSaveComment functions.

Vadim