EvSND

This Send function references another cell and sends its value to the database when you select Send and Refresh Schedules.

The parameters specify the dimensions that identify where the data value is to be sent in the database. EvSND returns the value from the database to the referenced cell. You do not need to add any EvGET functions to the sheet to return values to the cell. Since the values are returned to the referenced cell, Planning and Consolidation sends only the cells that have changed since the last send in the current session.

By putting the formula in the EvSND cell and not in the input cells, you decrease the chances of your formulas getting overwritten or erased. To further protect the formulas, you may want to hide the EvSND cells in the input schedule.

This function takes members that not specified from the current view settings.

Syntax Syntax

EvSND(ValueReference,AppName,[dim:]member1,[dim:]member2,...[dim:]memberN)

ValueReference — The cell reference of the input cell.

Insert AppName

Insert Member1–N

End of the code.

Example Example

The following example sends the value in cell D16 to the database.

EvSND(D16,Finance,Salaries,Budget,Jan2008)

End of the example.