Skip to Content
Author's profile photo Jeffrey Holdeman

Tip on Using Data Manager Package IMPORT_USING_FTP in SAP BusinessObjects Planning and Consolidation, version for NetWeaver

If you have used the SAP Business Objects Planning and Consolidation (BPC) Data Manager package to load a flat file you will know you must first import the file onto the BPC server before running the load package.  But what if you have sensitive data like a payroll file and you want to limit the potential for someone to access a file they are not permitted to view?  Then you may want to automate the transfer of data from a source system into BPC.  For this type of use case, there is a Data Manager package called IMPORT_USING_FTP which allows BPC to pick up a file from an FTP site and import the data in a single step.

The Import_Using_FTP package works fine for all versions of BPC for NetWeaver if your FTP site containing the source file allows anonymous FTP login.  But unfortunately there is a bug in this Data Manager package in BPC before Support Package 10 of BPC NW 7.0 and before BPC NW 7.5 Support Package 05 which causes the package to fail if the FTP site has anonymous logon disabled.  Naturally, when dealing with sensitive data, you would not allow anonymous logon to the FTP site, so the IMPORT_USING_FTP package has not been a workable option for many BPC users.

SAP Note 1504226 has been released for BPC 7.0 NW SP10 and BPC 7.5 NW SP05 to fix the problem the IMPORT_USING_FTP package does not work if anonymous access is disabled on the FTP server.  If due to your application lifecycle you are not able to install the support package or, even the SAP note individually, then you can utilize the following work around to be able to use the IMPORT_USING_FTP package.

From BPC Excel, go to the modify package option for your Data Manager package.

Modify_Package 

Click on the Advanced button.

Advanced_button

In the script window, change the highlighted reference from %FtpSourceFile% to %DestinationFolder% and save the change.  Below is the original script.

Script_Before

The following screen print shows the corrected script.

Script_After

The changed line should read as follows:

TASK(/CPMB/CONVERT,FILE,%DestinationFolder%)

Below shows the package execution prompts with a working example.

Run_PKG

SAP Note 1504226 fixes a problem with the BPC Data Manager package IMPORT_USING_FTP.  But if you need to utilize that feature before applying the note, then just follow the simple steps explained in this work around.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Jeffrey Holdeman,

      Thank you for your post, it's very helpfull.

      Do you know if it's possible to load a file with a dynamic name? We should load a file present in FTP server every 3 hours but the name is changing.

      Regards,

      Jean-David

      Author's profile photo Jeffrey Holdeman
      Jeffrey Holdeman
      Blog Post Author

      Hi Jean-David,

      I am not aware of a way to use the FTP import package with a dynamically changing file name.  As you can see the prompt is expecting a specific file name and path.  Perhaps you can change your process for generating the files to write each new file with the same name.  Or maybe you can use some kind of OS trigger and script to copy the dynamic file to the constant.file name. 

      Perhaps you will want to log your requirement on the BPC group on the SAP IDEA Place.  https://cw.sdn.sap.com/cw/community/ideas/businessanalytics/epm_bpc_netweaver

      Best regards,

      Jeff