upload flat file on SAP BPC with comments

mayiya · ‎2019 Aug 30

Hi experts.

I need to upload a flat file to BPC. The problem is that the flat file is coming like this:

1. How can I map the time on transformation file?

2019.01=*COL(4)

2019.02=*COL(5)

2. How can I upload the comments on flat file to comments on BPC?

I´m using SAP BPC 10.1 NW.

Thanks.

Maria

former_member186338 · ‎2019 Aug 31

To upload file with multiple time id's in the line use MVAL in mapping section of transformation file!

About comments - not clear what time ID has to be used to store comment!

But anyway - for comments load you have to create routine badi...

Another option is to load data from BPC report using VBA to fill cells from text file.