In previous releases, the Query Panel used to query Excel or Text files and Free-Hand SQL allows you to rename objects and change their qualification or data type. In SAP BI 4.3, this Query Panel is replaced by the one used for Universes, Web Intelligence Documents, SAP HANA, or SAP BW data sources.
This means that in SAP BI 4.3, there is only one unique Query Panel used for all data sources, including the new OData and Google Spreadsheet data sources. Users are offered a unified experience and common capabilities. Indeed, in this Query Panel, you can select the objects to include in the query, add filters to the query, preview query results, define a maximum number of rows,…
For the time being, the following capabilities are not yet supported for the new Text, Excel, Free-Hand SQL, Google Spreadsheet and OData data sources:
- Combined queries,
- Sub-queries and list of values of objects when defining a filter. Only constants and prompts are supported,
- Query stripping.
But these capabilities should be available in future releases.
You can change a Text, Excel, Free-Hand SQL and Google Spreadsheet resource file by clicking the Browse button in the Query panel toolbar. Note however, that the new data source file must have the same structure as the original one.
Object Properties are no longer set in the Query Panel, but in a new Properties tab once you have run the query.
Note
For more information, please refer to Unit: Working with Formulas and Variables - Lesson: Editing Objects Properties.
In order to identify icons used to represent objects more easily, some of them have been changed compared to SAP BI 4.2.
