EPMCommentPartialContext

Applies to: Planning and Consolidation connections.

This function retrieves all comments associated to a set of dimension members that is partially defined. Any members not specified in the function is ignored.

For example, if your model contains the following dimensions: Account, Entity and Time. In the function, you do not specify a member for the Time dimension, then all comments entered for any period are returned.

Parameter	Description
connection name	Name of the connection. For details about the syntax you must use, see Connection Name Parameter - Syntax.
member1	Name of the member from which to retrieve associated comments. Optional.
...
member25	Name of the member from which to retrieve associated comments. Optional.

Note A comment is displayed by default in the cell in which you have entered the fonction. However you can use the Show as Microsoft Excel Comments option in the Sheet Options to display the comment as a standard Microsoft Office Excel comment, when you mouse over the cell.

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 Refresh Refresh Workbook .