Skip to Content
Technical Articles
Author's profile photo Marc Bernard

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

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:

  • v3.0
    • 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
  • v3.7
    • Added link to documentation of BW workspace solution as standard alternative to this how-to solution- Included chapter in documentation about required authorizations
  • v4.0
    • Support for upload and downloading comments (characteristics as key figures)- Improved error messages when uploading files in CSV and TXT format
  • v4.1
    • Added option to sort columns of data preview (file preview is always sorted the same as the file format)- Added optional URL parameters for defining maximum number of visible rows for file and data previews
  • v4.2
    • Added optional URL parameter for displaying “logoff” button and redirecting to a target URL after logoff
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!

Best,
Marc Bernard
@marcfbe

Assigned Tags

      253 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Uwe Jakobi
      Uwe Jakobi

      Hello Marc,

      thank you for your quick and helpful answer!

      Best regards, Uwe

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog 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

      Author's profile photo Timo Schmid
      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

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog 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

      Author's profile photo Cornelia Lezoch
      Cornelia Lezoch

      Hi Timo, hi Marc,

       

      at my current project we also would like to integrate the file upload functionality into a web template,

      expecting that with the upload we would not encounter locking errors and the user can edit the uploaded data right after upload in the planning mask.

      What would be the best way to integrate the functionality into a web template?

      Is it as Timo write to create a custom web item that call the web dynpro?

      Would it also work, if we just integrate the planing sequence (that includes the file upload function) into a button in WAD?

       

      thanks and best regards

      Cornelia

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog 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

      Author's profile photo Nico van Setten
      Nico van Setten

      Hi,

      I have issue with FF upload using hierarchy-variables. Confguration i use is AFO 2.6 sp01 x86 32 bit with workbook/excel 32bit.  Webdynpro exits with 500 server error. But ST22 mention ASSERTION FAILED. When debugging webdynpro ZRSPLF_FILE_UPLOAD it exits at   component Views, method  ONACTIONON_UPLOAD.

      READ TABLE lt_fields INTO ls_fields WITH TABLE KEY m_id l_id.
      ASSERT sysubrc 0.

      But it starts in method WDDOMODIFYVIEW  where variables are handled.

      When i use hierarchy node in planningfilter, it works but not desired as user needs auth on all  nodes. If we use hier variable then it stops.  In debugging we see that variable is a type 2 variable and that values are not saved by the program. As we also use in same test type 1 variable we see it comes through.   Is there a version where type 2 variables work properly?

       

      Thanks

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Nico,

      There is no support for hierarchy node input variables (see the HTG, 3. Prerequisites, Limitations).

      Sorry, I don't have any solution.

      You might be able to use an exit variable (select-options) and derive the single values from the hierarchy node (which you somehow have to pass to the ABAP backend first).

      Best,
      Marc
      SAP HANA Competence Center

       

      Author's profile photo Aleksandrs Frolovs
      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.

      Author's profile photo Alexey Lantsman
      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 

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog 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

      Author's profile photo Frank Klingl
      Frank Klingl

      Hi Alexey,

      with AO 2.7 those planning function are now working.

      See

      Regards

      Frank

      Author's profile photo Former Member
      Former Member

      Hi Marc.

      I've been using your utility for good few years now with good results. However we have recently upgraded to 7.5 and consequently imported new version of the tool. As a result it stopped working.

      It seems that new version performs file format checks in a different way. In version we used previously, one of the KF to upload was with currency but there was no currency in the file. Instead, variable exit of the very first variable in the filter was reading first record of the file and determined currency based on its content. This doesn't work anymore, apparently new function is checking file consistency (here-missing currency) before variable exit. When I set currency as fixed in planning filter, upload works, even though I stil don't see exit variables setting locks in rsplse.

      I was wondering where is a proper place to apply code to continue using application as we did before i.e. being able to set variables based on the first record of uploaded file, instead of setting them upfront.

       

      Thanks,

      Marcin

       

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Marcin,

      In general, the filter is set before the file is processed by the planning function (upload). This means defining variables has to happen before the actual upload function. Something like this is not foreseen. The file content is stored as an attribute in the assistant class (by the WebDynpro). You can use this in your exit. However, it's in raw format and you will need a bit of ABAP to get to the actual key figure or currency key value.

      Best,

      Marc

      Product Management SAP HANA DW

      Author's profile photo Former Member
      Former Member

      Hi Marc,

      We have tested and retested behaviour in BW 7.3 SP8 and BW 7.5 SP5 (with only change being new version of upload function applied from the note). I am 100% certain that variables in 7.3 are called again after data is imported in its raw format (i.e. after click on upload button) to BW and we did all the ABAP to read it and use for exit variables.

      First variable has also logic to validate file / data format, then other are used for derivation of values (e.g. is sales org in first record is S001 then Company Code determined by variable is DE01).

      In 7.5 exit variables run only once, even before user click on browse. this means we cannot set variables depending on loaded data. I wonder if there is any way to restore behavior from 7.3?

      Regards,

      Marcin

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Marcin,

      chapter 5.13 lists a few SAP Notes related to this issue. Please make sure you have SAP Note 2200044 implemented with the proper RSADMIN switch.

      Best,

      Marc

      Product Management SAP HANA DW

       

      Author's profile photo Tomas Varga
      Tomas Varga

      Hi Marc,

      I want to upload full backup of InfoCube to the system, I am getting this error message when running a plan sequence:

      I am uploading a csv file downloaded from system, picked one line a changed a key figure to test the upload. Regarding the error I tried to enter in excel 10,010 change it to textto number, but there is no way forward.

      File Upload: Data conversion error Check if character format (encoding) is correct: DEFAULT 

      I have set up the filter like this (I was forced by the system):

      Answer much appreciated,

      Tomas.

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Tomas,

      you have to be careful which program you use to edit a file. Excel probably saved it with a different character encoding (for example "Western European Windows" format). You can change the format under File > Save As > More options > Tools > Web options.

      Either use a Text Editor that keeps the character encoding of the original file or change the character format in the upload function.

      Best,

      Marc

      Product Management SAP HANA DW

      Author's profile photo Tomas Varga
      Tomas Varga

      You are absolutely right, thanks for your remark.

      Author's profile photo Yann Chagourin
      Yann Chagourin

      Hi

      what is the character encoding that works?

      In the web options, I saw that my xls is set on "western european windows". I changed to unicode, utf8, us-ascii, no luck.

      Regards

      Yann

       

      Author's profile photo Yann Chagourin
      Yann Chagourin

      Found it: there was a "scandinavian" character in my data set. ø is not accepted in the upload... Changed it to o and it worked.

      Author's profile photo Former Member
      Former Member

      Hi Marc,

      i am having issues with values for two fields after Uploading files and refreshed the data,

      System transposes the the values of the two fields to each other.

      e.g before the download lets say field A- 1.000 and field B- 2.000, After the upload and refresh the Data the value Transposes to A- 2.000 while B- 1.000. please what might cause the problem and possible way to fix this.

      My email is pacificsam01@gmail.com.

      Thanks

      Sam

       

       

      Author's profile photo Sabine Jacob
      Sabine Jacob

      Hi Marc,

      I am just wondering if the upload would work also for new master data together with values?

      Thanks a lot for a short information.

      Kind regards

      Sabine

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Sabine,

      no. Master data must exist before plan data can be loaded (unless of course an InfoObject does not have a master data table). It's the same with any planning function.

      Best,
      Marc
      Product Management SAP HANA DW

      Author's profile photo Former Member
      Former Member

       

      Hi Marc,

      we are trying to import the transports into our HANA 7.5 SP 6 and receive the following error message

      Does this ring a bell?

      thanks for any pointers

      Regards

      Manuela

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Manuela,

      the transport is compatible with 7.3 and higher. Please import with "ignore component versions" turned on.

      Best,

      Marc

      Product Management SAP HANA DW

       

      Author's profile photo Iksit gadhia
      Iksit gadhia

      Hi Marc

      We are migrating BW to v7.4 so upgrading from v2.4 to the v3 version of this file upload.  v3 works on new system for uploading actuals, target etc. but I have a commentary upload (ie no key figures in upload file) which doesn’t work. Running the planning sequence and selecting te file through gui or web just says ‘0 records read’.

      If I run the same file using 2.4, it reads and updates. (I would just use 2.4 but it doesn’t wok via web, only through gui)

       

      any advice?

       

      Thanks for your help!

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Iksit,

      I'm not aware of this issue. Could you please send me an email?

      Best,

      Marc

      Product Management SAP HANA DW

      Author's profile photo Thomas Neugebauer-Spreng
      Thomas Neugebauer-Spreng

      Hi Marc,

      is it possible to upload or download characteristics as key figures with your solution? I stil post this question even though I fear I already know the answer …

       

      kind regards & keep up the good work  ?

      Thomas

      Author's profile photo Former Member
      Former Member

      Hello, Marc!

      Thanks for great updates for the solution!

      I have a question about authorizations concept. using authorizations, provided in appendix, leads to errors while save process. web dynpro is getting started, but it's unable to save data, system generates error message "you have no authorization for info-cube Z* with 02 ACTVT".

      is it necessary to set 02 actvt for this operation? or may it be local error in customized roles? please advice

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Elena,

      yes, the user needs change authorization. Please adjust the role accordingly.

      Best,

      Marc

      Product Management SAP HANA DW

      Author's profile photo Former Member
      Former Member

      Hi Marc,

      I have configured the file upload functionality and it works fine. The user is presented with a web layout where they enter varialbles, browse and upload their files. However now the users want to to upload large files (around 2 million records). The Web layout takes about 25 mins for the upload. However the ask is if this can be pushed to a "background" job. Which means the user uploads a file to a shared folder and the Planning Sequence is called through a process chain passing the File Name as a Variant. Will this work?

      Regards,

      Prasanth.

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Prasanth,

      the upload was never intended for mass data. That's also documented in the how-to guide (PDF). It's much better to use the standard file upload feature for BW.

      There is an option to run the file upload planning function in batch but it's not integrated with the web UI. You would specify the file name on the application server (has to be accessible from AS ABAP) in the planning function parameters. Then schedule the corresponding planning sequence as a process chain. Two challenges: Setting the right variable values and concurrent planning sessions/locking. For a single user case, these are easy (hard code the variables in the process chain, tell the user not to change data at the same time) but for multiple concurrent planning users this won't be easy especially if they need to plan on the data at the same time.

      Let me know if you make this work in a productive environment 🙂

      Best,

      Marc
      Product Management SAP HANA DW

       

      Author's profile photo Former Member
      Former Member

      Hi, Marc.

       

      I've seen that not only me has the issue with characteristic as key figure.

      I tried a simple scenario. A direct update DSO with planning mode - ON is included into aggregation level. In DSO I have an object for comments which is set to characteristic as key figure.

      And I can plan it for example in RSRT. I checked this.

      But when I use File upload tool I have no errors, but any text placed in "comments" column is being converted to 0.

      Is there any possibilities to work with characteristic as key figure. Or may be you can give a cue how(in which method) it can be solved?

      Thank you.

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Yuri,

      I have a solution ready for testing. Please send me an email.

      Best,

      Marc
      Product Management SAP HANA DW

      Author's profile photo Prasanth Gandlur
      Prasanth Gandlur

      Hi Marc,

      Is this fixed with Version 4.0. I am have an agg level on a DSO with comments in a column. When I load the data it says 1 records read and 0 generated. Although the file has 12 records in it with comments.

      Regards,

      Prasanth.

      Author's profile photo Prasanth Gandlur
      Prasanth Gandlur

      Never Mind. The comments upload only seems to work only for Comment Characeteristics with Master data, if not it does not do anything.

      Regards,

      Prasanth.

       

      Author's profile photo Former Member
      Former Member

       

      Hi Marc,

      I am testing the function in BW on Hana 7.5 SP6.

      It works well initially, but despite having set the planning fucntion to X -Overwrite - once I have loaded the data one time and activated it (ADSO is set like planning cube - all char are key) if I try loading the file again, it gives me

      Error while reading data; navigation is possible (BRAIN289)

      Upload xxx ended with errors

      Message no. RSPLF114

      Any Idea what I am doing wrong?

      regards

      Manuela

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Sorry, Manuela. I don't know why this is happening. Please open an incident so SAP Support can take a look.

      Best,
      Marc
      Product Management SAP HANA DW

      Author's profile photo Former Member
      Former Member

      Hello Marc,

      I am using BPC 11 system BW4HANA version. I have implemented the note you have suggested (Version 3). Unfortunately it was not working.

      Will you please help us the latest note no for flat file upload via planning ? Version 4 or something for BW4 HANA?

       

      BR,

      Arup.

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Arup,

      the solution also works for SAP BPC 11, version for SAP BW/4HANA. Please use version 4 of the solution which you can find attached to SAP Note 2053696.

      Best,
      Marc
      Product Management SAP HANA DW

      Author's profile photo Former Member
      Former Member

      Thanks Marc. It is working.

      Author's profile photo Klaus Koblinger
      Klaus Koblinger

      Hi Marc,

      the import for small files works well, but now I have a problem with a lagre file with 200 columns.

      Is there a limitation in the planning function?

      The field "File Format" only displays 250 chararcters.

       

      regards Klaus

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Klaus,

      The display of the format will just be concatenated on the parameter screen (which you show). The file format can be as wide as you like. If you send me an email, I can provide a program to upload the file format from a txt file.

      Best,
      Marc
      Product Management SAP HANA DW

      Author's profile photo Christian Gieler
      Christian Gieler

       

      Hi Marc, we use your solution with great success in our excisting planning solution on BW 7.3. Now we wanna create a new planning tool on BW/4HANA with BPC 11.0. Will there be a future solution for your upload Tool? Or is it an standard function for BPC 11 in the future?

      We really need such a flexible upload possibility also for then new solution 🙂

      Tnx for your response

      Christian

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Christian,

      the solution also works for SAP BPC 11, version for SAP BW/4HANA. Please use version 4 of the solution which you can find attached to SAP Note 2053696.

      Best,
      Marc
      Product Management SAP HANA DW

       

      Author's profile photo Christian Gieler
      Christian Gieler

       

      Perfect! Many tnx for the quick reply

      Author's profile photo Uwe Jakobi
      Uwe Jakobi

      Hello Marc,

      now that our customers start using your valuable upload function within the embedded BW of our simple finance implementation, we came across a strange issue: F4 help does not work properly in some cases, the "Search" button seems to be with no function.

      Are you able to have look into our issue 580950 / 2017? I think you will need to look into our system to believe it. 😉 As expected SAP does not give standard support on this.

      Thank you and best regards
      Uwe

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Uwe,

      The solution is in the customer namespace but still build using standard SAP components. In your case, it's ABAP WebDynpro with an SAP Search Help and this should work of course just like in other standard SAP applications. I will take a look at the issue and get back to you via your customer message.

      Best,

      Marc

      Product Management SAP HANA DW

      Author's profile photo Former Member
      Former Member

      Hello,

      We are currently using your enhanced version of File Upload in our project. Unfotrunatelly we noticed one problem. The order of columns that are displayed in the File Preview is correct and consistent with the fields order definition in the FILEFORMAT parameter of the planning function. We would expect that also the Data Preview will show the columns with the correct order. But here the order is different and seems random. Is it possible to correct/change the order somehow? I tried to create a new view with the changed layout of the Data Preview. The problem is that this view is then available only for the specific user.

      Is it possible to create a view that will be available and initial for all users?

      Is it possible to transport this setting to other systems?

      I raised an Incident for this issue but SAP Administrator asked me to contact directly with you.

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Wojciech,

      good observation and questions. No one has complained about the field order yet... I get the point and understand that it's not optimal. The order is given by the internal data structures used by BW-IP.

      The data is displayed using a standard Web Dynpro ALV control. The initial view is configurable. Here is the documentation:

      Personalizing SAP List Viewer
      https://help.sap.com/viewer/7b44f2a7728810148a4b1a83b0e91070/7.5.9/en-US/86916011b96f4d4bb6279b5f369e3534.html

      Configuring Standard ALV Functions
      https://help.sap.com/viewer/7b44f2a7728810148a4b1a83b0e91070/7.5.9/en-US/493e0d64347d3ef0e10000000a421937.html

      Specifying the Initial View of Applications
      https://help.sap.com/viewer/7b44f2a7728810148a4b1a83b0e91070/7.5.9/en-US/493e1189347d3ef0e10000000a421937.html

      I have not had much time to play with it but there is one limitation: The fields are defined dynamically based on the aggregation level. If you are using the upload for several different levels, then I believe you won't be able to have different initial views. :-(.

      So... I enhanced the solution to allow you to maintain the initial order of columns separately per planning function. If you are able to update to a new version, send me an email and I will provide it to you for testing :-).

      Best,
      Marc
      Product Management SAP HANA DW

       

      Author's profile photo Vandersteen Jorg
      Vandersteen Jorg

      Hello,

       

      I'm trying to use the BADI's method transform_file to transform a keyfigure-based file to an account based format.

      To my surprise, the method transform_file is called in step 6 of the planning function logic while method _convert_string_to_tab is called in step 3, so I can't transform the data in the file to match the planning function.

      Do I misunderstand the use of this BADI?

       

      Kind regards,

       

      Jorg

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Jorg,

      transform_file is the correct place do change the format. For example, the file contains KF1, KF2, KF3. You also need to include ACCOUNT and AMOUNT (as empty fields) if it's not included yet.

      Then you can transform the records in c_t_file and move the data from each KF to a new record with the corresponding ACCOUNT and AMOUNT.

      The file upload will then ignore the KFx fields and take the data from ACCOUNT and AMOUNT (which obviously need to be in your aggregation level).

      Best,
      Marc
      Product Management SAP HANA DW

      Author's profile photo Alexander Kutz
      Alexander Kutz

      Hi Marc,

      great piece of code!

      I have a feature request: I would like to run the execution with packaging (described here: https://help.sap.com/saphelp_nw70/helpdata/en/45/946677f8fb0cf2e10000000a114a6b/frameset.htm - in the execution of a planning sequence in process chains you can select it ). Currently it seems that it runs without packages but I have the need to write the planning buffer in-between. Is it possible to integrate this as a flag maybe in the URL as a parameter?

      Best regards,

      Alexander

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Alexander,

      The complete upload function works on the premise of a single file that is processed in one package. So, unfortunately, this is not feasible to allow for automated packaging.

      However, you should be able to create your own set of filters and either add them as separate steps to the sequence or use several sequences within a process chain.

      Best,
      Marc
      Product Management SAP HANA DW

      Author's profile photo Andreas Wetzel
      Andreas Wetzel

      Hi Marc,

      thanks for this great development.

      Unfortunately we were struggling with our secured namespace because of the '/'.

      If we use the comment function we need use characteristics as a key in the direct-update DSO. The generated InfoObject name will contain '&' and this InfoObject name is a problem when calling function module RSD_IOBJ_INCL_ATR_NAV_GET.

      This problem could be handled by replacing this '&' and the generation namespace prefix by the original namespace.

      Do you think you can add this in the next version?

       

      Best regards

      Andreas

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hallo Andreas,

      It's best to check this case in your system. Please create an incident report and ask support to forward it to my name.

      Best,
      Marc
      Product Management SAP DW

      Author's profile photo Andreas Wetzel
      Andreas Wetzel

      Hello Marc,

      incident 204833 / 2018 is created. Not sure if it is already forwarded to you.

      Thanks and regards

      Andreas

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Andreas,

      the solution is now available via SAP Note 2053696 as well.

      Best,
      Marc
      Product Management SAP DW

      Author's profile photo Oliver Precht
      Oliver Precht

      Hello all,

      is it possible to create / delete columns in the download file planning function type?

      Best regards

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Oliver,

      the file format can contain InfoObjects that are not included in the aggregation level. You can fill them using a BAdI.

      If you do not want an InfoObject in the output, just don't include it in the file format.

      Best,
      Marc
      Product Management SAP DW

      Author's profile photo Joseph Anthony Estevez
      Joseph Anthony Estevez

      Hi Marc bernard,

       

       

      i tried to follow sap note step by step guide(2053696)

       

       

      but i tried to test the planning sequence i encountered an error

      File Upload: Unable to open file: C:\Users\Raytejana\Documents\SAP\SAP GUI\SAP_BEX_FI

       

       

       

       

      thanks in advance,

       

      Ray Tejana

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Ray,

      when you execute the file upload in transaction RSPLAN, then as a default, a fixed file name and path are used (defined by SAPworkdir environment variable).

      Change the file name in the parameters of your upload planning function to "Prompt". Then the system will ask you for the file name in RSPLAN.

      Note: This is usually only for testing. Your planning users will use the WebDynpro and select the file that way.

      Best,
      Marc
      Product Management SAP DW

       

      Author's profile photo Ray Tejana
      Ray Tejana

      Hi Bernard,

       

      Thank you for your fast reply,

      i tried  uploading this sample excel data.

      but encountered errors.but it seems more of master data issue. should i load the info cube first to recognize the data? apologies this is first time implementing IP

       

       

      and also  about WebDynPro  as mentioned in  the guide to access it via webdynpro i need to

      http://(customer server):(port)/sap/bc/webdynpro/sap/zrsplf_file_download_v3?
      planning_sequence=FILE_SEQ2

      FILE_SEQ2 is the name of my sequence

      already activated the service but when i tried to access the link but its unreachable.

      should  be seing the interface of the upload program?

      is there a step i missed or is this something that basis team can help me?

       

      thanks,

       

      Joseph

       

       

      Author's profile photo Ray Tejana
      Ray Tejana

      hi bernard ,

       

      i successfully accessed the UI the problem is more of the security issue.

       

      i tried to upload but i still recieve the same error messages

       

       

       

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Joseph,

      you have to maintain the master data for the characteristics Version and Customer first.

      Best,
      Marc
      Product Management SAP DW

       

      Author's profile photo vincent pele
      vincent pele

      Hi Bernard,

      We extensively and successfully implemented your application for our client, this is really powerful thanks ! We are only struggling with one open point: in the data selection header we need to restrict the F4 value help to the list of authorized value. We can do it using the F4 restriction BADI ; we have created a variable, put it in the filter, and also created associated BADI implementation ; this is working fine if we use the variable in a BEX query for instance. However, if we open the Webdynpro application, the variable is present in the data selection, but in any case the value help is restricting the values as defined in the BADI. The BADI is not even triggered actually, when putting an external break-point this is not going inside.

      Any insight ? Do you think we can open OSS message for that ? I am not 100% how to what extend your solution is supported by SAP officially i mean.

      Many thanks.

      Best regards,

      Vincent.

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Vincent,

      the F4-Badi is supposed to work also with the WebDynpro. Please check that the enhancement implementation ZRSPLF_F4_ENHANCEMENT is active in transaction SE19 and the code is present in the active version of function RSD_CHA_HELP_VALUES_EXIT. The start of the code should look as follows:

      FUNCTION rsd_cha_help_values_exit.
       """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""$"$\SE:(1) Function Module RSD_CHA_HELP_VALUES_EXIT, Start                                                                                                   A
       *$*$-Start: (1)---------------------------------------------------------------------------------$*$*
       ENHANCEMENT 1  ZRSPLF_F4_ENHANCEMENT.    "active version
       
      

      I suggest to put a break-point into this RSD function. It should call the F4-Badi from there.

      Best,
      Marc
      SAP HANA Competency Center

       

       

      Author's profile photo vincent pele
      vincent pele

      Thanks Marc for your quick and clear response !

      I am not sure to get you 100% still... :

      • indeed ZRSPLF_F4_ENHANCEMENT needed to be adjusted, i did it.
      • indeed when putting a break point this is triggering RSD_CHA_HELP_VALUES_EXIT.

      >> However in debug this is still not going into my implementation of enhancement spot RSR_VARIABLE_F4_RESTRICT where my custom code to restrict the list is actually defined in an implementation class calling method IF_RSR_VARIABLE_F4_RESTRICT~GET_RESTRICTION_FLAT.

       

      Am i missing something obvious in here ?

      Thanks again.

      Best regards,

      Vincent

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Check that the enhancement spot implementation has the correct filter i.e. proper name of the InfoObject that is used behind the variable.

      Best,
      Marc
      SAP HANA Competency Center

       

      Author's profile photo vincent pele
      vincent pele

      Hi Marc,

      Thanks, actually i am concerned because yes the enhancement implementation is properly configured, and actually this works smoothly when i try to execute the planning sequence in RSPLAN. But when opening the WebDynpro then there is no restriction anymore and if i put an external break-point inside the enhancement spot it does not go inside.

      Do you think we can open OSS message to get support on this ? (except if you have other ideas to suggest).

       

      Thanks again !

      Regards,


      Vincent 

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      I tested it again and the F4-BAdI is certainly called by the WebDynpro as well. Please create an incident with open GUI and HTTP connection (have it forwarded to me).

      Best,
      Marc

       

      Author's profile photo vincent pele
      vincent pele

      Hi ! Thanks a lot.

      I have created ticket, it should be forwarded to you:

      357702 / 2018 F4 value help BADI not triggered in Webdynpro Upload File

      Meanwhile i have asked for system opening. It may take a few days, there is no emergency on this topic for the time being.

       

      Best,

      Vincent

      Author's profile photo Ramona Cotiuga
      Ramona Cotiuga

      Hello, any update on this topic. I get the same issue:)

      Thank you!

      Author's profile photo Sharad Srivastava
      Sharad Srivastava

      Hello Marc,

       

      I am trying to upload a CSV , after some transformation which results in a huge data set ( C_th_Data has finally more than 30 million records ). The upload takes a lot of time in the process  EXECUTE_SERVICE (CL_RSPLFR_CONTROLLER)  and fails due to internal memory issue.

      Can we skip the above process and as I do not need any validation.

       

      Please note the transforamtion works fine for a small set of data.

       

      Thanks,

      Sharad

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Sharad,

      please see the note in chapter 2 of the how-to guide:

      There's no way to improve performance or reduce memory consumption of the upload for such high data volume. Sorry, but planning functions - not just the file upload - are not designed for this.

      Best,
      Marc
      SAP HANA Competency Center

      Author's profile photo Sharad Srivastava
      Sharad Srivastava

      Thanks Marc for the quick response.

       

      If I reduce the volume to 5 million would it still be considered as a mass upload ?

       

      Thanks,

      Sharad

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      The file upload will have C_TH_DATA and at least one copy (sometimes several copies) in memory. Several million records probably still lead to memory issues. You will need some trial and error to find the maximum for your system (also with other concurrent users).

      But please, no complains about performance. If you want a fast load (that also requires less memory), use ETL.

      Best,
      Marc
      SAP HANA Competency Center

       

      Author's profile photo Sharad Srivastava
      Sharad Srivastava

      Thanks Marc .. 🙂

      Author's profile photo Ricarda Seyb
      Ricarda Seyb

       

      Hello,

      is it possible to integrate a button for a logout?

      Only closing the web browser is in some cases not enough to cancel a lock.

      Thank You and best regards

      Ricarda Seyb

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Ricarda,

      interesting request. No one ever asked for it... but it was easy to implemented. Please send me an email, so I can send you a version for testing.

      Best,
      Marc
      SAP HANA Competency Center

      Author's profile photo Sebastian Gesiarz
      Sebastian Gesiarz

      Hi Marc,

       

      could you please tell how what is the expected behavior for the field conversion marked with 'X' for the field value that has already been provided the user in the system format?

      e.g. user inputs YYYYMMDD and not DD.MM.YYYY for 0calday

      Asking this as it currently generates an error without description - "File Upload: Table conversion error.".

       

      If it is how it is supposed to work, would you be so kind and propose some workaround so both formats are supported?

       

      "Field conversion:
      If the "Convert Fields" setting is turned on, field values are interpreted
      according to user settings (see below)."

       

      Would very much appreciate your reply.

       

      Thanks in advance &

      Kind regards,
      Sebastian

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Sebastian,

      the file upload is using the same logic as the standard GUI_UPLOAD to parse a line of the file and separate it into fields. With field conversion turned on, this logic will validate data types, which includes the user's date format settings. So the user must supply dates in the format they see everywhere else in SAP. If field conversion is off, there's no such check.

      Since this is not coding of the file upload, I won't be able to change or adjust it. The only way around it, is to upload in XML (which is unlikely to be accepted).

      The remaining alternative is to keep field conversion off meaning all values must be in internal format. However, what you can do is program your own conversion logic in the provided BADI and method transform file from user entries to internal values. You will have to do it for all fields and obviously cover the cases that any user might come up with (or you define). A bit of programming but doable.

      Best,
      Marc
      SAP HANA Competency Center

       

       

      Author's profile photo Sebastian Gesiarz
      Sebastian Gesiarz

      Thank you!

      Appreciate your prompt reply as UAT's are live.

       

      Have a good weekend!

       

      Best,

      Sebastian

      Author's profile photo Aleksandr Sidorin
      Aleksandr Sidorin

      Hi Marc,

       

      could you clarify the situation about "New Standard File Upload functionality" (I mean planning function type 0RSPL_FILE_UPLOAD_AO): is it possible to upload an .xls (not .csv) file using this standard function? Or the only way to achieve this is to use your Z-development?

      We are on BWonHANA 7.50 SP12, AO2.7.

       

      Thanks,

      Alex

       

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hello Alex,

      the standard solution is documented here:

      https://help.sap.com/viewer/69ec98e0c0e54128a61c32f3255fa438/11.0.5/en-US/142ff737ee8c46a4811192fc22bcc38b.html

      It does not support XLS, just CSV format.

      Best,
      Marc
      SAP HANA Competency Center

      Author's profile photo Pan Aaron
      Pan Aaron

       

      Hi Marc,

      It's a great tool for users who require mass download and upload data.

      I currently faces two problems:

      1. when downloading data with DATE type infoobject and with field conversion on, the field content is truncated to only 8 characters irrespective of my user profile. e.g. 20180725 would be downloaded as '25.07.20'  when my profile has date format 'DD.MM.YYYY'
      2. The second issue is I can download the file through RSPLAN, but when I try to download it through webdynpro, I can the following error message as soon as I click Download button.

        500 SAP Internal Server Error

        ERROR: The ASSERT condition was violated. (termination: RABAX_STATE)

      do you know what could be the problem? How do I troubleshoot this?

       

      Regards,

      Aaron

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Aaron,

      I tested it and the download of date works correctly and as designed. I tried all formats and it looks to me like you picked "Text (fixed)" format (plus "Convert field = X). This will lead to the behaviour you see since as you know, the date field has only 8 characters. If you want to see the complete date, select "Text (Tab-delimited)" (or CSV). The fixed format makes sense only if you leave convert fields off.

      I was unable to reproduce the second issue. Please check that you have the latest version 4.2 of the solution installed. If you can't figure it out, send me the complete dump from transaction ST22.

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Pan Aaron
      Pan Aaron

       

      Hi Marc,

      according to note, v4.2 only works for BW7.5 and BPC 10.1. Our system is still on BW7.4 and BPC 10.0. We have installed v4.0.

      For the first issue, I have fixed it manually for now by changing the _CREATE_DATA_STRUCTURE method line 17. When infoobject is of type D, instead of assign it D(8) type to the field in the structure, I have assigned it C(10) so that it will capture the full string of converted date '25.07.2018'. This has solved the issue for now.

      For the second issue, I'm still trying to troubleshoot where the problem is. It seems to throw an error even before it hits the planning function program.

       

      Regards,

      Aaron

       

      Regards,

      Aaron

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      That's a misunderstanding. Any v3 or v4 works starting from SAP NetWeaver 7.3. If you have SAP NetWeaver 7.4 or higher, then you need any v4 version... Of course, the latest is always the best. So v4.2 should work for your system.

      Best,
      Marc
      SAP HANA Competence Center

       

       

      Author's profile photo Pan Aaron
      Pan Aaron

      Hi Marc,

      ok. I will deploy it and try again. Just one suggestion, can you change your document to clarify this misunderstanding?

       

      Regards,

      Aaron

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Done. The 4.2 document contains a compatibility matrix.

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Pan Aaron
      Pan Aaron

       

      Thanks

      Author's profile photo Pan Aaron
      Pan Aaron

      Hi Marc,

       

      Does this tool allow us to download/upload the text instead of key of field? It is not very user-friendly for business users as most of the time it is hard to interpret what key represents.

       

      Regards,

      Aaron

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Aaron,

      that's a good point. You can enhance the solution to include the texts: In the download file format, add some fields for the texts (like 0TXTLG). Then use the TRANSFER_FILE enhancement spot to fill the text fields (chapter 5.7 in the guide).

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Pan Aaron
      Pan Aaron

      Hi Marc,

      Thank you for you suggestions. I'm just back from holiday and testing this. For this to work, I need to define both key and text of the field as output fields in the 'File format' of the planning function. What if I only want to output text field in the file? Is it achievable using BADI as well?

      Similarly, I only want to have text as a input in the upload file.

       

      Thanks & Regards,

      Aaron

      Author's profile photo Alexandra VARYUTA
      Alexandra VARYUTA

      Hi, Marc!

      When we're trying to upload and save data to a direct update DSO short dump occurs.

      Category ABAP Programming Error
      Runtime Errors SAPSQL_PARSE_ERROR
      Except. CX_SY_DYNAMIC_OSQL_SEMANTICS
      ABAP Program SAPLRRSI
      Application Component BW-BEX-OT

       

      In the error there is a reference to a characteristic which we're using as a key figure -"/BIC/ZBP_DESC (comments a stored there).

       

      We're on BW 7.4 SP16. The planning model is very simple: Write Optimized DSO -> Aggregation Level. Error occur  when we press on the save button.

       

      Thanks for any further assistance.

       

      Regards,

      Alexandra

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Alexandra,

      planning is only supported for InfoCubes and Direct Update DSO. If you are using a Direct Update DSO, please create an incident.

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Alexandra VARYUTA
      Alexandra VARYUTA

      Hi Marc,

      Just an update.

      Problem was caused by derivation that we're using to record changes in planning data (logging - user, time, document id).

      We turn of this functionality and switched to BADI RSPLS_LOGGING_ON_SAVE.

      It helped.

       

      Regards,

      Alexandra

      Author's profile photo Cao Tuan Chau
      Cao Tuan Chau

      Hi Marc,

      I am using Version 4.0 . Is there a possibility to hide the warning messages with the parameter Show_messages?

      Regards,

      Tuan

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Tuan,

      yes, that should work but you might miss some messages that are important for the user. Try show_messages=EXA.

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Cao Tuan Chau
      Cao Tuan Chau

      Hi Marc,

      I tried out your suggestion, but still the warnings are displayed. Do you have another idea?

      Regards,

      Tuan

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      see below

      Author's profile photo Cao Tuan Chau
      Cao Tuan Chau

      Hi Marc,

      thank you for the solution. I will update the Version and test it again.

      Regards,

      Tuan

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Tuan,

      messages related to parameters of the planning function could not be hidden. I enhanced the solution so it should now be possible. Please download the v4.2 zip again from SAP Note 2053696 and install transport K900495.CBW

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Felix Steigmeier
      Felix Steigmeier

      Hi Marc,

      thank you for updating the tool so steadily! We also want to use the upload with "column = time period" and therefore to suppress the warnings is useful. Even though we have to keep in mind that locks are displayed as warnings will not be shown when surpressed.

       

      Regards

      Felix

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Felix,

      Always a pleasure to make it more useful. Changing a few lines of code here or there is no problem.

      The lock messages are coming from the IP framework and not the planning function itself. Therefore, the lock warning is still visible even if you use show_messages=EXA.

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Sebastian Gesiarz
      Sebastian Gesiarz

      Hello Marc,

       

      Could you please tell if it is possible to round floating point key figure upload with nine decimal places (max) to the way BEx does it?

      Even though the same Key Figure is used for the flat file upload, the values uploaded via the flat file differ from the ones in the file and in the Input-Ready Query.

      Please find a sample below.

       

      Scenario:

      User loads via the flat file: 0,00089465

      Stored in the DB is:  8,9464999999999998E-04 (0,000894649999999999)

      Displayed in the query is: 0,00089465

      On the input-ready query zero post attempt, posted to the database is: -8,9465000000000009E-04 (-0,00089465)

       

      Result: Values do not match and do not sum up.

       

      Thanks in advance &

      Kind regards,

      Sebastian

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      Hi Sebastian,

      floats can be tricky. Unfortunately, we can't guarantee precise numbers which is due to the nature of how floats are stored (i.e converted to binaries). And this becomes more difficult in cases you have to add several floats together as is often the case in planning.

      https://launchpad.support.sap.com/#/notes/2529372

      Best,
      Marc
      SAP HANA Competence Center

      Author's profile photo Sebastian Gesiarz
      Sebastian Gesiarz

      Hi Marc,

       

      got it, thank you.

      Seems like 'inevitable' change 😉

       

      Best,

      Sebastian

      Author's profile photo Maria Ruseva
      Maria Ruseva

      Dear Marc and SAP experts,

      is it possible to set the decimal separator to be always dot in the upload function for txt files?

      thanks and regards,

      Maria

      Author's profile photo Raf Boudewijns
      Raf Boudewijns

      in the new standard planning function (0RSPL_FILE_UPLOAD_AO) that is possible

      Author's profile photo Sharad Srivastava
      Sharad Srivastava

      Hello Bernard,

      Does the File upload for BW IP support time dependent master data upload ?

      Eg . if a particular Profit Center is invalid on the day of upload ,will it throw error  or will it pass as it is  a valid master data ( is there any additional settings involved).

      Thanks ,

      Sharad

      Author's profile photo Harikrishna G
      Harikrishna G

      Dear Marc,

      Any plans to support Hierarchy node variables in Upload flat file . Or still to be planned for an enhancement.

      Author's profile photo Guido Zani
      Guido Zani
      Hi Marc,
      I'm trying to Upload a ".txt" positional file. Everything works fine when i set "File Format" parameter with a list of InfoObjects followed by KF but as soon as i set "File Name" with a mix of InfoObjects and KF (which is my target) i start getting some errors:
      -"File Upload: Field conversion error. Line: 1".
      -"File Upload: Check if the correct decimal notation was used".
      NOTE:
      1) KFs are set with a custom domain which fix the N.Character according to the N. of dedicated digits in the file.
      2) If i switch the order (IO before KF) both in the "File Format" and txt everything works fine.
      I know there's a limitation with the DOWNLOAD Planning Function ("The file format must contain all characteristics first, followed by all key figures. If characteristics and key figures occur in a mixed order, the file download will NOT aggregate the data properly!"), is that true even with the UPLOAD?
      Thanks Again for your valuable blog.
      Regards,
      Guido
      Author's profile photo Patrick von Aufschnaiter
      Patrick von Aufschnaiter

      Hi Marc,

      Can you please share where the current solution can be downloaded?

      The SAP Note mentioned above does not work.

      Thanks,

      Patrick

      Author's profile photo Larbi HARICHE
      Larbi HARICHE

      Dear Marc,

       

      Thank you for your solution. My client is using it.

      Nevertheless, recently we made an upgrade of S4/Hana from the version 1610 to 1909, and we started having some issues with file upload. System is replacing blank values with # and saving that to the ADSO, which is highly impacting data quality. We are planning to open an incident.

      Do you have any idea about similar issue ?

       

      Thank you,

       

      Regards,

      Author's profile photo Omar Díaz Juárez
      Omar Díaz Juárez

      Hello Marc,

      We are using this functionality with great results. However, we have lately came across an unexpected scenario, and wanted to ask to what extent that would be supported?

      We are trying to setup multiple filters in the as part of the planning function e.g. 001.2020 and 002.2020 should be allowed. However once more than one value is setup in the filter, message "Value of characteristic 0FISCPER: 001.2020, is not included in the selection" starts coming up.

      Thank you,

      Omar

      Author's profile photo Peter Brothers
      Peter Brothers

      Hi Marc

      We have been using the file upload planning function for many years (v3) and it is working out well for us.  We are in the middle of an upgrade from 7.4 to 7.5 and migrating to HEC. When testing the planning function from the HEC server we notice that the updates are occuring to the cube on the on prem server.  I set the debug parameter on the on prem server and can clearly see the zcl_rsplf_file_upload is running there.  I know you must be busy, but if you could point me in the right direction without taking too much time, it would be appreciated.

      Best regards

      Pete B.