The EvMBR (Member) function allows you to select a member from Member Lookup dialog box by double-clicking on the cell that contains the formula. The selected member ID is returned as the value of the cell.
The EvMBR function is similar to the EvCVW function, but EvCVW is used to change the current view for its associated dimension. The EvMBR function returns the ID of the selected member to the cell without changing the current view. See EvCVW
You can use this function to change, for example, the member for a page, row, or column key that must be hard-coded in the report or input schedule, and does not have to come from the Planning and Consolidation current view.
Syntax
EvMBR(AppName, MemberID)
Insert AppName
MemberID — The ID of the member to display in the cell.
Example
The following example returns the Stats member in the cell. If you double-click on Stats within the workbook, the Member Lookup dialog box is displayed. You can select another member to display in that cell.
=EVMBR(FINANCE,Stats)