SAP Knowledge Base Article - Public

2542454 - How to replace/change the data source in the existing Analysis Office workbook

Symptom

It is necessary more information about how to replace a data source in the existing workbook.

Environment

SAP Analysis for Microsoft Office

Resolution

  1. Open the existing workbook in Analysis Office;
  2. Go to the Design Panel (in case it is not visible, click on "Display" > "Display Design Panel");
  3. Click on tab "Components";
  4. Select the data source;
  5. Click on the pencil besides "Data Source Name".
    Change data source option.png
  6. 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