Automate Flat file upload into BPC File system

[SreekanthSurampally]

Hi,

We got a requirement to automate the process of uploading a flat file into BPC file service, so that a DM package can be scheduled after that. We wanted to avoid this manual action of uploading a flat file into BPC every day.

We also have another option to update this file data into BW DSO or Cube and then upload into BPC after, it can be completely automated. However, we would like to not to store the data physically in BW tables,

so with that, we are trying to find a way to upload the data into BPC file service automatically. Please provide me if there is any way to do it.

Thanks

Sreekanth

[Former Member · Accepted solution]

Hi Sreekanth,

where is the uploaded file before you upload to BPC?

to make it automated it must be in the SAP system or connected drives, ftp and so on.

you can create a abap program that will get the file and upload to bpc.

then think one step further, is it transnational data you want to upload? then why not write those data to the bpc model in one step?

Andy

[SreekanthSurampally · Accepted solution]

Hi Andy,  Currently the file is uploaded into BPC manually from a shared drive,  what do you mean the file must be in SAP system or drives?

I will need to move the file from shared drive to BPC file system automatically on a certain time every day,  if there are any standard programs or approach to do this, will be helpful.

also, Yes, it is transactional data. Writing the data in BPC model means, is it through input schedule update?

[Former Member · Accepted solution]

Hi Sreekanth,

there is no standard process to upload file from share drive to BPC.

if you still need to run process after you upload the file into BPC then why not just write one custom program that will read from the share drive and post values into BPC model in one step?

Andy

[former_member186338 · Accepted solution]

You don't need to upload file from the shared drive, you can always configure ftp access to the shared drive (Windows, Unix, etc...). Then use import data directly from ftp location.

Vadim

[SreekanthSurampally · Accepted solution]

Hi,  I have followed the solution provided on the following thread, directly updated the network file path while executing the DM package (Import data from flat file), it works fine.

https://scn.sap.com/thread/3757392

[former_member186338 · Accepted solution]

Yes it's an alternative to ftp access to any other server!