The problem occurs when you have multiple monitors hooked up to your computer, open Smart View, connect to an Essbase database, open the Member Selection dialog and then move it onto your second monitor. Smart View remembers where you moved the dialog and will display it there the next time you open the dialog. The problem is, if you no longer have your second monitor attached, the dialog will display off-screen.
I took a look at the registry and found there is a DialogPositions setting in the registry under HKEY_CURRENT_USER\Software\Hyperion Solutions\HyperionSmartView\Options.
I found that you can close Excel/Smart View, delete the DialogPositions parameter from the registry, and restart Excel and the Member Select dialog will again be displayed centered on the main monitor.
You can make this easier for end users by creating a registration entries file. On my machine, I created a text file and named it ResetSmartViewDialogs.reg. In this file, I added the following lines:
To run the file, just double-click on it and you will be warned about the changes to be made to the registry. Simply confirm that you want the entries to be made and the offending DialogPositions setting will be removed.