Skip to Content
0
Former Member
Aug 01, 2005 at 09:19 AM

Workbook having queries on different BW servers

10 Views

Hello,

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).

Regards

Pranay Dave