Show TOC

Data Transfer and Save - SAP BW (INA Provider) ConnectionsLocate this document in the navigation structure

Applies to: SAP BW (INA Provider) connections.

When working on a SAP BW (INA Provider) connection, you can perform the following save actions.

Transfer the data entered

All changed data is transferred to the user buffer and they are checked for consistency. If the changed data is correct, the data is recalculated, the amounts are updated and displayed in the input forms. The data remains in the user buffer as long as the user is connected. When the user logs off, the data is removed from the user buffer.

You can either transfer the data entered on the current worksheet or transfer the data entered on the entire workbook. To do so, select one of the following:
  • Start of the navigation path Transfer Data  Next navigation step Transfer Worksheet Data End of the navigation path
  • Start of the navigation path Transfer Data  Next navigation step Transfer Workbook Data End of the navigation path
A confirmation message is displayed.
Rollback the data

You can undo all changes since the last save of your data to the database. To do so, select Rollback Data.

All the data is rolled back, including the data from the user buffer.

Save the data to the server

When using the Save Data feature, the behavior is as follows:

  • The new or modified data since the last transfer is automatically transferred to the user buffer.
  • All the data is saved to the database, including the data from the user buffer. So, potentially:
    • when clicking Save Workbook Data or Save and Refresh Workbook Data, data from the user buffer (already transferred) initially coming from other workbooks than the current one are also saved to the database.
    • when clicking Save Worksheet Data or Save and Refresh Worksheet Data, data from the user buffer (already transferred) initially coming from other worksheets than the current one are also saved to the database, and data that has not been transferred for the current worksheet is transferred automatically.
You can perform the following save-related actions:
  • Save the data entered in the current worksheet.
  • Save the data entered in the current workbook.
  • Save the data entered in the current worksheet and then perform a refresh.

    Data is first saved to the server, then data is refreshed in your input form, taking into account the data you have saved and recalculating the amounts accordingly. For example: you enter data for January, February and March. You select Start of the navigation path EPM Next navigation step Save Data Next navigation step Save and Refresh Worksheet Data End of the navigation path. As the data form is refreshed from the server, the sum of the three months you have entered is displayed for Quarter 1 in the input form.

    • If the option Refresh only Data on "Save & Refresh Data" is not selected in the User Options, everything that is in the current worksheet is refreshed: the data of the reports, the data of the EPM functions, all the reports (including local member data, formatting, and so on).
    • If the option Refresh only Data on "Save & Refresh Data" is selected in the User Options, only the data for all EPM functions and all the reports (except the data for local members) in the worksheet is refreshed.
    Note The Save and Refresh Worksheet Data is the default save action when you directly click the Save Data button.
  • Save data entered on the current workbook and then perform a refresh.
    • If the option Refresh only Data on "Save & Refresh Data" is not selected in the User Options, everything that is in the current workbook is refreshed: the data of the reports, the data of the EPM functions, all the reports (including local member data, formatting, and so on).
    • If the option Refresh only Data on "Save & Refresh Data" is selected in the User Options, not everything that is in the current workbook is refreshed but only the data for all EPM functions and all the reports (except the data for local members) in the current worksheet is refreshed.
Note If you do not want to send the parent data to the server, unselect the user option Send Parent Data to the Server on "Save Data". In the save data confirmation message, only the number of base member data will be displayed. By default, this option is selected and all data are sent to the server.
Note If you want the save-related messages to be displayed, select the Display Warning when Saving Data or Comment option in the User Options. If the option is selected, as soon as you perform a data save, a dialog box opens, prompting you to confirm if you want to save x data (if there is no data to save, the message says so); if you confirm, a message appears, informing you if the data has been saved or not.

For a specific input form, you can choose not to save the data entered on specific members. For more information, see Read-only Data.

Related Information