Skip to Content

Automate file uploading process in BPC

Hello,

Is it possible to automate the file uploading process which we do from data manager in BPC ? Can we automate this via a macro ? We have a requirement that a csv file named prov_2020_07 stored in a folder called /Provisions gets automatically uploaded via the macro.

I have written below line of code which triggers the upload file prompt automatically but the user still has to click browse and fetch the file and upload on server folder. Can we automate that part too ?

Sub upload()
Dim cofCom As Object
Dim epm As Object
Dim api As Object
Set cofCom = Application.COMAddIns("SapExcelAddIn").Object
cofCom.ActivatePlugin ("com.sap.epm.FPMXLClient")
Set epm = cofCom.GetPlugin("com.sap.epm.FPMXLClient")

epm.DataManagerOpenFileUploadDialog
epm.DataManagerRunPackage "IMPORT", "Data Management", ""
epm.DataManagerOpenViewStatusDialog

End Sub

Regards,

Neha

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 12, 2020 at 11:58 AM

    Just define the network folder in AL11.

    Then you will be able to import data directly from the file located in AL11 folder. And you can use vba macro. I have written about it number of times.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 11, 2020 at 05:52 PM

    Neha,

    Yes you can do it. It's pretty straight forward.

    1) Create / Define an event in SAP BPC using tcode SM62.

    2) Your script should execute an "event" Get more info on events here .

    3) In SAP BPC you should schedule job that is "event" based from tcode SM36.

    So when an event is triggered, the background job will automatically execute and load the file.

    I would recommend that you add a notification when the job completes. SM36 has a button to specify the email recipient.

    Drop a note here if you require more information.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.