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 ?
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: