I need to implement a workbook, in where the queries are from different BW machines.
Ofcourse the workbook is on one of the machines.
So my question is that is it possible to use VB macro which does the following:
- Refresh query1 which is on the same machine as the workbook
- Refresh query2 which is on a different machine (would require disconnecting current machine, automatic login to other machine and refreshing the query).