I have recently begun using BQ to run some reports. Does anyone know how to change the data provider after a report has been written (I.e. from a test environment to production)? In BO this would be done thru the DataManager.
Secondly, the BQ help says that you can write a macro to schedule reports to run at off-peak times. I have duplicated the macro, but am unsure how it executes on its own at these off-peak times. Has anyone experimented with this and gotten it to work?
Assuming each environment has its own universe, you can point a report to a different universe via Data -> View Data (Definition tab). Click the ellipsis following the universe name to select a different universe.
Since you are specifically asking about BusinessQuery. The only thing I can think to do is to publish is to open up the .bqy file in BO instead of BQ. Then you can repoint the way George recommended and then Save As a .bqy file. Then you can simply refresh your spreadsheet and …