Show TOC

EPMScaleDataLocate this document in the navigation structure

This function retrieves data for a full set of members, and scales the data. Any member not specified is taken from the context.

The data is divided by the number entered in the scale parameter and the result is displayed in the selected cell.

When using a Planning and Consolidation connection, the division is performed only on accounts that are scalable. If an account is not scalable, the original amount is displayed in the cell.
Note You can view the "scaling" property of an account by selecting it in the sheet and then selecting Start of the navigation path EPM Next navigation step More Next navigation step Properties End of the navigation path.
Parameter Description
connection name Name of the connection.

For details about the syntax you must use, see Connection Name Parameter - Syntax.
scale Scale value. Mandatory.
member1... to member24 Optional.
  • Name of the member.
    Note If using the Time dimension and if several hierarchies exist, fully qualify the member or else an arbitrary hierarchy is chosen by the system.
  • 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 orStart 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.