Automatically change datasource for several workbooks
is there any possibility to change the data source (source system) of several workbooks at once? We have several BW systems with lots of queries with only one test BO Machine. Each BW system has the queries, but with different data (for example for tests of large projects).
BW-Query Q123 on BW systems BW1, BW2 and BW3 (transported with BW-Transport)
Analysis-Workbook W123 with connection to Q123 on BW1 on BO System BO1 (transported with the promotion management from development system)
This Workbook has to be copied to:
W123-2 with connection to Q123 on BW2 on BO System BO1
W123-3 with connection to Q123 on BW3 on BO System BO1
We know that we can make a copy of the query and change the data source manually, but for let's say 50 workbooks or even more that's too much effort (as it has to be done several times if there are new versions).