SAP Analysis for office woorkbook's: Data source is not changed after a migration

Hello,

We are about to migrate our BEX Woorkbooks to SAP Analysis for Office?

As seen above, we have tested the transport of a report migrated from the BO dev environment to the BO test environment. It works but the query still points to the dev. Is there a way to convert the source of the query automatically?

Thank you

Norman