Function EvMBR

The EvMBR (Member) function allows you to select a member from Member Lookup dialog box by doubleclicking 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.

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 BPC current view.


Syntax
EvMBR(Application Name, Member Name)

Parameter                                                              Description
Application Name                                         The name of the application.
Member Name                                             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("SALES","PRODUCT")