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.
Click on the Advanced button.
In the script window, change the highlighted reference from %FtpSourceFile% to %DestinationFolder% and save the change. Below is the original script.
The following screen print shows the corrected script.
The changed line should read as follows:
TASK(/CPMB/CONVERT,FILE,%DestinationFolder%)
Below shows the package execution prompts with a working example.
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.
No comments:
Post a Comment