Changing the data source of a document is no longer limited to Universe, SAP BW and SAP HANA data sources. In SAP BI 4.3, you can do it even for query based on a Web Intelligence, Excel, Text or Free-Hand SQL data source. The target query can be another existing query or a query created on the fly on a Universe, an SAP BW or an SAP HANA data source.
When you click Query → Change Source in Design mode, you can select any query from the document in the Select a Query dialog box. In previous releases, you could only select a query based on a universe, SAP BW or SAP HANA.
Then, in the Change Source dialog box, for the target query, you can select the:
- Choose an Existing Data Source from the Document radio-button to select another query of the document.
- Specify a New Data Source radio-button to create another query. The Select a Data Source dialog box opens but only with the Universe, SAP BW and SAP HANA options. For other data source types, you need to first create the target query before running the Change Source and then select Choose an Existing Data Source from the Document radio-button to select this query.
For Excel, Text or Free-Hand SQL data sources, it is recommended to use this new Change Source functionality rather than the Change Path. This is especially true when the two data sources differ since you can explicitly map objects; which cannot be done through the Change Path.