Skip to Content
Technical Articles

How-to… Load a File into SAP NetWeaver BI Integrated Planning (Part 2)

Update (August 2014):

Version 3 of the how-to guide and solution has been released. Please see the blog at

How-to Load a File into BW-Integrated Planning (Version 3)

Note: The old version 2 is not compatible with SAP BW 7.4 or higher. If you are planning to upgrade to 7.4, you will have to install version 3!

 

Hello Friends,

thanks to your great feedback the updated solution is more robust and provides several enhancements. For example, it is now possible to upload a data directly from a BEx Analyzer workbook without promting the user for a file name. I have also implemented a file download application which closes the circle: Download, change file, upload, done!

Version 2.4 is now available. The new features are described below.

Please read How-to… Load a File into SAP NetWeaver BI Integrated Planning (Part 1) first.

Update: Please check the “known issue” section when upgrading to Enhancement Package 1 for SAP NetWeaver 7.0.

Download

There are two parts to download and another to check afterwards:

Enhancements

The first enhancement allows you to upload the file without prompting the user for selection criteria and a file name. This functionality can be used when you are running BEx Analyzer Workbooks. Save the plan data to a file (for example with VBA), then call the planning sequence for the upload by selecting a corresponding button on your workbook. The file upload will then pick up the file direclty from the PC. No further questions asked. Please see section 4.12 of the how-to paper.

The second enhancement is around the variable selections for the upload. The first version was limited to only single value variables. Now full selection options are available! The following types of characteristic variables are supported: single values, multiple values, intervals, and complex selection options.

Together with the selection options I also implemented support for personalization of the variables. The selection screen is therefore prepopulated with the values that are stored in the personalization (DataStore 0PERS_VAR).

The limitation on InfoObjects in the file format was removed. Now all InfoObjects can be used to define the file format. If the InfoObject is not included in the aggregation level, then it will simply be ignored.

File Download Application

Of course when you can upload files, you also want to download files. Right? The new version includes a file download application. It works very similar to the file upload. On the initial screen you enter the variables – in the example “Planning Version” – and pick a file format for the download. You can select “Text (Tab delimited)”, “Text (Fixed length)”, or “XML”.

Download Begin

When you choose “Download” the system will process the plan data with a planning function and provide a link for downloading the file to the PC. In the log you can see how many records where downloaded.

Download Middle

Further Enhancements

Version 2.3:

  • Support for user exit variables. Variable needs to be of type “characteristic value” and not ready-for-input. The exit is called with i_step = 1.

Version 2.4

  • Support for key figure values with thousand separator. The upload uses the setting from the user profile.
Your Feedback

Please keep your feedback coming. Post your requests for enhancements or ideas for additional features as comments to this blog.

Known development requests:

  • Support for hierarchy node variables (no plans)
  • CSV file format (no plans)
  • Preview of data before save (thinking about it)
Bug Fixes

All previously identified program errors have been fixed in version 2.4 of the solution.

Version 2.1:

  • Included missing HTTP service in transport
  • Disabled variable and file browse fields after selecting “Upload”
  • Fixed incorrect data during merge phase when field conversion is turned on
  • Fixed runtime error CALL_FUNCTION_CONFLICT_GEN_TYP when field conversion is turned on
  • Added automatic conversion of URL parameter to upper case
  • Fixed runtime error when using variables on attributes
  • Fixed a locking issue. Now plan data is properly unlocked after a save or undo.

Version 2.3:

  • Fixed error when variable is restricted to single value but field is not included in file

Version 2.4:

  • Fixed error when uploading key figure values with decimal comma

New bugs:

  • None

Known issues:

  • If you get a syntax error in WDDOONCONTEXTMENU, please update to BI ABAP support package 13 (SAPKB70013). As a workaround, go to SE80, select the Web Dynpro Component ZRSPLF_FILE_UPLOAD, navigate to view FILE_UPLOAD_VIEW and delete method WDDOONCONTEXTMENU manually. Then proceed the same way for Web Dynpro ZRSPLF_FILE_DOWNLOAD.
  • If you have no input variables at all and just exit variables, then the upload with display message “No variables defined for planning sequence. All data will be locked!” However, the exit variables still work and will lock the data properly. Here’s how to test it:
    – Start the upload web dynpro
    – Pick a file and select “upload”
    – Start GUI and go to RSPLAN > Locks
    – Check the lock entries for your InfoCube. You should see the locks based on your exit variables.If you want to suppress the message go to SE80 > Web Dynpro ZRSPLF_FILE_UPLOAD > View FILE_UPLOAD_VIEW > Method WDDOMODIFYVIEW and change the following line:
    *     No variables defined for planning sequence
    *     add_message( i_msgty   = ‘I’ i_message = ‘043’ ).  “<<< delete
  • If you upgrade to Enhancement Package 1 for SAP NetWeaver 7.0, please implement SAP note 1315474 “WD ABAP: Message Area is not visible”

Best,
Marc Bernard
@marcfbe

322 Comments
You must be Logged on to comment or reply to a post.
  • Hello Mark,

    Greetings..!!

    I have question, For Example we have to do the Planning on the DSO (Direct Update) and below are the Scenarios:

    1.) We have to upload the Data to DSO using Planning File Upload Functionality.

    2.) On the Same DSO we have to perform the Row wise/Manual Planning.

    Could you please let me know, Is this requirement is feasible or not.

     

    BR,

    Su.