Show TOC

EPMSaveDataOnlyLocate this document in the navigation structure

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

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

Once you have defined the function, refresh the worksheet. In the specified cell (first parameter of the function), the latest data that you have entered is displayed (the cell is empty if you have never entered any data). 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. The cell in which you entered the function always displays the data from the database, whereas the cell in which you entered data displays the latest data you entered.

Parameter Description
cell Cell in which you enter 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.

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.