Show TOC

EPMContextMemberLocate this document in the navigation structure

This function retrieves the context member for the specified dimension. When you double-click the cell containing the function, a dialog box opens, displaying all the members for the specified dimension. You can select another member and the context is changed. The list of members can be optionally filtered, using the dimension properties.
Note
  • Make sure that double-click actions are enabled (the Enable Double-Click option must be selected in Start of the navigation path EPM Next navigation step Options Next navigation step User Options End of the navigation path).
  • If the cell on which you double-click is merged with other cells, the double-click will not function.
Parameter Description
connection name Name of the connection.

For details about the syntax you must use, see Connection Name Parameter - Syntax.
dimension dimension name. Mandatory.
filter Filter by property to return only members with specified property values. Optional.
context member name Displays the same member name as the one displayed the Context bar. Optional.

If you enter FALSE or do not specify anything, the ID of the member is displayed in the cell.

If you enter TRUE, the member name that is displayed in the cell is the same member name as the one displayed in the Context bar.

Example

EPMContextMember("Finance","Entity","CALC=N;GROUP=SALES"). For the Financial Consolidation connection, the context member of the dimension Entity is displayed in the cell. If you double-click the cell, a dialog box displays a list of all entity members filtered by CALC=N and by GROUP=SALES.