Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Analysis for Office: change system connection in workbook


We are on SAP BO 4.0 SP04 and Analysis for Office 1.3.

Before in Bex Analyzer, we could open an workbook and connect and disconnect to our dev system and connect and disconnect to our production system using the same workbook (when the same query is available in the both systems).

How is this functionality possible in Analysis for Office? It seems once i have created a workbook on a query in our dev system, i can not disconnect and connect this workbook to the query in the prod system ?

Kind regards,

Guy Verschueren

Former Member replied


you can change a datasource from within the design panel, in the components tab. Here a screenshot for reference, you have to click on the marked red squares:

Best regards,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question