a) Create an object in Designer and the build a condition in the Query Panel which will prompt the user for a value, the assign it to the connection.
OR
b) Create a UserForm with the selection of Connections on offer. Call it from the BeforeRefreshEvent.
There is a Connection Object in BO and in Designer, both related to the Universe in use.