EVGTS: The EVGTS (Get value and scale) function retrieves a data value based on the SPECIFIED MEMBERS, and scales the value if the scale property is enabled on the dimension. The report templates provided in the sample application set have a scale reference in the Control Panel area of the template.

EVSND: 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, BPC 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.

EVGTS: The EVGTS (Get value and scale) function retrieves a data value based on the specified members, and scales the value if the scale property is enabled on the dimension. The report templates provided in the sample application set have a scale reference in the Control Panel area of the template.

EVSND: 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, BPC 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.