In EPM add-in there is function named “Activate Member Recognition” in Sheet Options.
After you activate the option , you can enter members directly in a cell of a report.
And for the same member in different dimensions , you can enter the member in a cell as: dimension name|dimension member name.
For example :
There are two dimensions named “A” and “B”.
They have the same dimension member named “test”.
So after activated the ‘Member Recognition’ option in EPM add-in client , you can enter the member as A|test or B|test in a cell.