Symptom
It is necessary more information about how to replace a data source in the existing workbook.
Environment
SAP Analysis for Microsoft Office
Resolution
- Open the existing workbook in Analysis Office;
- Go to the Design Panel (in case it is not visible, click on "Display" > "Display Design Panel");
- Click on tab "Components";
- Select the data source;
- Click on the pencil besides "Data Source Name".
- Select the system and the new data source.
Note: the data source will be inserted with its initial navigational state. Selecting the same data source will also reset the navigational state (e.g. previous filters, drilldowns, etc).
See Also
Chapter "The Components tab" in User Guide of AO.
Keywords
replace, data source, query, change, reset, lost, change datasource, change data source, data source Alias, datasource alias , KBA , BI-RA-AO-XLA , Excel Addin , How To
Product
SAP Analysis for Microsoft Office all versions