We are in process of moving a lot of Analysis for Office (AfO) workbooks from a SAP BW environment to the SAP BusinessObjects BI Platform. Besides storing the workbooks on BI Platform, we of course want to use the OLAP connection on the BI Platform to connect to BW, instead of using the direct – locally defined – connection from AfO to BW.
AfO has a nice feature to quickly swap source systems, but it is a bit hidden. We are using Analysis for Office 2.3 by the way.
1. Open the workbook you want to migrate. Make sure your workbook is not connected to the BW system. Display the Design Panel, go to the Components tab and select your workbook. Right-click to Log Off.Analysis for Office, Knowledge sharing