Show TOC

EPMSaveDataLocate this document in the navigation structure

Applies to: Planning and Consolidation connections; SAP BW (INA Provider) connections.

This function enables you to retrieve data from the database in a specified cell and to modify the data, for a full set of members. Any member not specified is taken from the context.

Once you have defined the function, refresh the worsheet. In the specified cell (first parameter of the function) and in the cell in which you entered the function, the data from the database is displayed. Enter data in the specified cell. Then, perform a save, using the Save Data button. The entered data is saved to the server. When refreshing again, data from the database is displayed in both cells.

When using a SAP BW (INA Provider) connection:
  • If the "Access Type for Result Values" have not been set to "Master Data" in BEx Query Designer, you cannot save the data entered on empty cells.
  • When you click the Transfer Data button, the entered data is saved on a server area dedicated to your user.
Parameter Description
cell Cell in which the data is retrieved from the database and in which you can modify the data. Mandatory.
connection name Name of the connection.

For details about the syntax you must use, see Connection Name Parameter - Syntax.
member1... to member24 Optional.
  • Name of the member.
  • Or name of the context favorite. If you enter a context favorite in Member1, leave the other member parameters blank.
Note
  • If the description of a member exists in several dimensions, once you have entered the function, a message appears, stating that the description is ambiguous and recommending that you use the ID of the member instead.
  • If the ID of a member exists in several dimensions, once you have entered the function, a message appears, stating that the ID is ambiguous and recommending that you use the full unique name of the member instead.
  • Please note that the EPMSaveData function does not support free text key figures.

This EPM function is executed when you refresh the worksheet or the workbook by selecting Refresh or Start of the navigation path Refresh Next navigation step Refresh Worksheet End of the navigation path or Start of the navigation path Refresh Next navigation step Refresh Workbook End of the navigation path.

Remember

This cell function has to be used for ad-hoc data and must not be used to replace the EPM reports. If a performance issue occurs when using this cell function, please design an EPM report instead.