Hello Friends of Integrated Planning,

thank you very much for all the feedback I received on the File Upload/Download how-to over the past years. I have great news: Basically every development request has been implemented! Yes, this means that there is a big load of new features available with version 3. Upload and download of CSV files and a new user interface that allows the preview of the file and plan data before you save it are just two of the highlights. The new version is also compatible with SAP BW 7.4.

Prerequisites

Minimum release to use the new version is SAP BW 7.30.

Download

You can download the complete how-to guide as well as the solution from SAP Note 2053696.

Enhancements

The following list shows the changes and enhancements in version 3 compared to the previously published version 2.4:

  • Enabled conversion exit in variable screen
  • Removed context info from message output (can be enabled again with show_messages parameter)
  • Added search help for all selection fields including special characteristics like fiscal period
  • Added check that 0INFOPROV must be filled for uploads on MultiProviders
  • Support for CSV format for upload and download (new parameters for data separator and escape character)
  • Improved auto-detection of file format
  • Added info messages to display version and detected file format
  • New parameter for checking for duplicate records
  • New parameter to define display of +/- sign for download
  • New and improved alternative user interface
  • Function to generate the required master data for ZIP_* InfoObjects
  • Added BADI for performing custom transformations during upload and download
  • Integrated File Upload/Download with Report-Report-Interface
  • New parameter setting for download to select field description instead of technical name in header line
  • Automatic recognition of UTF byte-order-mark during upload
  • Added ready-for-input variables for all parameters
  • v3.1

    – Added support for XLS format for upload with SAPGUI

    – Added load from application server which enables upload from Analysis Office

  • v3.2

    – Minimum release increased to SAP BW 7.30

    – File Upload is now supported for SAP BW 7.40

    – Updated screen shots to show GUI-based planning modeler and web-based file upload/download application

  • v3.3

    – Added enhancement to support F4-BADI

    – Added option to sort variables on selection screen

    – New option to display instructions and support information to end-users

  • v3.4

    – Added support for formula variables

    – New option to set maximum number of visible messages in log

    – Added support for exit variables which are ready for input

  • v3.5

    – Download of key figures other than “Amount” or “Quantity” will take “Decimal” setting in to consideration when using “Convert Fields” option

  • v3.6

    – Improved error message in case of character format/encoding issues

    – Added detection of incorrect field separator (semicolon instead of comma and vice versa)

    – New Standard File Upload functionality

    – Support for Advanced DataStore Objects for SAP BW powered by SAP HANA

Preview

Here are a few screen shots of the version 3 user interface (Note: The old UI is still available in the version 3 transport). For more details, please refer to the how-to guide (see “Download” section above).
File Upload Selection Screen:

BW-IP_File_Upload_Example_02.png

File Upload Preview Screen:

BW-IP_File_Upload_Example_03.png

File Download Selection Screen:

BW-IP_File_Download_Example_01.png

File Download Preview Screen:

BW-IP_File_Download_Example_02.png
Your Feedback

As always, I appreciate your feedback. It’s as simple as adding a comment to this blog.
Enjoy the new File Upload and Download for BW-Integrated Planning!

To report this post you need to login first.

142 Comments

You must be Logged on to comment or reply to a post.

  1. Mukesh Towari

    Hi Marc,

    Thanks for such a wonderful blog.

    We have a little different requirement in terms of options for loading flat file in the system:

    1. Can we perform load with multiple Amount/Volume column, each representing a time period?

    2. Can we use the characteristic relationship that we have maintained for infocube to derive the fields while performing the writeback of data to database?

    Your inputs will help us big way.

    Thanks Again for your valuable blog.

    Regards,
    Mukesh

    (0) 
    1. Marc Bernard Post author

      Hello Mukesh,

      yes, you can load files like you describe. However, you will have to use the BADI to transform your file structure to the structure of the aggregation level. There’s an example provided in the appendix.

      The upload automatically uses all characteristic relationships – just like any other planning function.

      Best,

      Marc,

      Product Management SAP HANA DW

      (0) 
  2. Timo Schmid

    Hi Marc,

    thanks again for your very useful solution.

    I integrated the file upload web dynpro into my web planning application.
    Now i have probles with the different prefixes of the webdynpro path when transporting from dev to test and prod.

    I implement a custom web item and compute the prefix as described by you.
    The cusom web item returns the prefix of my webdynpro path. But If I want to work with tis result running a JavaScript within

    <Body onload=JavaScript:”function();”>

    Can you provide a small example webtemplate code for showin how to use the result of the custom web item to generate the URL to the planning sequence.
    I think this would be very helpful to all.

    Thank you very much.

    Best regards
    Timo

     

    (0) 
    1. Marc Bernard Post author

      Hi Timo,

      I’m sorry, but I’m too busy with SAP BW/4HANA and won’t have time to develop this. I’m sure that others have coded it already. Please search in the community or ask for help there.

       

      Best,
      Marc
      Product Management SAP HANA DW

      (0) 
  3. Jonathan SABY

    Dear Marc,

    Unfortunaly, Hierarchy node variables are not supported yet in the how to solution but have you planned to develop it?

    Many thanks,

    Best regards,

    Jonathan

    PS. We are in BW 7.5 SP6, but we still use your solution because new standard file upload solution does not work properly yet.

    (0) 
    1. Marc Bernard Post author

      Hi Jonathan,

      Nice to hear that you are still using it (well, I know many customers are 😉 ). I’m sorry, but I’m too busy with SAP BW/4HANA and won’t have time to develop the enhancement for hierarchy node variables. If you come across a working WebDynpro for these variables, I’m happy to take a look and try to integrate it (if allowed to reuse the code).

      Best,
      Marc
      Product Management SAP HANA DW

      (0) 
  4. Aleksandrs Frolovs

    Standard function 0RSPL_FILE_UPLOAD_AO (file upload for analysis for office) doesn’t work and looks like it will not work for along time. See note 2461345 for more details.

    (0) 
    1. Alexey Lantsman

      Hi Marc,

      we encountered the same problem as Aleksandrs that planning function type 0RSPL_FILE_UPLOAD_AO is currently not supported within Analysis for Office. The note 2471638 suggests to wait. Do you have an idea in which version of Analysis it may be expected? It’s not included in the latest roadmap of Analysis for Office.

      Thank you, Alexey 

      (0) 
      1. Marc Bernard Post author

        Hello Aleksandrs, Alexey,

        I don’t know any details about the AO roadmap or when the upload function is planned for. Either continue to use the File Upload I provide or contact the AO team for more information.

        Best,
        Marc
        Product Management SAP HANA DW

        (0) 

Leave a Reply