Switching Smartview Query between connections
We have a number of queries that were created in our production environment. I would like to do some testing with them on some development we did in the test environment without having to recreate them. My active connection is to the test environment but when I try to refresh the spreadsheets it pops up a login box for the production connection. I don't see any option anywhere to change this. Any help would be greatly appreciated as we have multiple spreadsheets to test. Hyperion 11.1.2.2