Describing Query Properties

The Query Properties panel provides options such as:

• Max rows retrieved: Set the maximum number of rows to retrieve.
• Max retrieval time: Set a time limit, in seconds, after which the data retrieval process stops.
• Sample result set: Return a sample result set. To use fixed sampling, select Fixed. Sampling is not available in SAP BW queries. The Fixed option is visible but not active if your data source does not support it.
• Retrieve duplicate rows: Include duplicate rows in the results. In a database, the same data may appear in many rows. You can choose to return these repeated rows or only unique rows. This option is not available in SAP BW queries or if your database does not support it.
• Retrieve empty rows: Include empty rows in the results.
• Delete trailing blanks: Delete trailing blanks from data provider values.

For more information about this topic, please read SAP BusinessObjects Web Intelligence User's Guide

When you build a query, Web Intelligence automatically creates a script (such as SQL) to retrieve data from the database. You can view and edit this script and copy it to another application if you have the rights to do so.

If you change the script in the Query panel, remove an object, and add a different object to the Results Objects panel, the script is generated again.

• Identify and use the main panels and toolbar options in the Query panel.
• Adjust query properties such as row limits, retrieval time, and data options for precise results.
• View and edit the query script to customize data retrieval as needed.