Administrator options

QUERY > Advanced features > Administrator options

Back to

Administrator options

To access the administrator options, run Query as an administrator by right-clicking the Query desktop shortcut and then clicking Run as administrator.

In addition, administrator options are password protected. The default password is queryshuttleadmin. It is recommended that you change the default password to a unique password.

To edit admin options

On the Tools tab, click Options .
Click Admin Options.
Type the password. Click OK.

To allow users to create and remove joins between tables

Select Enable Creation of Joins in Query Builder.

To allow users to create and remove manual joins between mismatched fields

Select Enable manual join creation between mismatched fields.
Note: Mismatched fields can be processed only if Adaptive Query Throttling is enabled. For more information, see "Adaptive Query Throttling" in this topic.

Important: You can allow users to make joins between indexed fields and non-indexed fields or between fields of different character lengths by selecting Enable creation of joins on mismatched fields. However, joins on mismatched fields may degrade performance. Therefore, consider the implications carefully before you enable this feature.

To allow users to create joins on cluster and pool tables, and on views

Select Enable joins for cluster, view, pool tables.

To enable the use of InfoSets and SAP queries

Click Enable InfoSets/SAP queries.

To enable left outer joins

On the Tools menu, click Options.
In the left pane, click Admin Defaults.
Select the Enable Left Outer Join check box.

To allow all records to be downloaded

Select No Limit On Records to Download.

To enable adaptive query throttling

Select Enable adaptive query throttling. The setting is enabled by default.

To allow users to manage string padding of criteria

Select Allow users to manage string padding of criteria.

Padding is applied automatically, for Num, Char, Numchar, and string values, unless query developers select to remove it. Padding improves the accuracy of the data extracts and is important for extracting the correct values from SAP.

To specify the maximum number of records a user can download

In the Max. number of records to download box, type the number you want. The default is 1 million records.

To specify the maximum number of tables a user can add to the query builder

In the Max. number of tables in query builder box, type the number you want. The default is 4 tables.

Query execution time outs

You might have to specify the length of time that QUERY waits during a query execution before it times out.

To set a query execution time out

In the Query execution time out box, type how many seconds you want QUERY to wait before it times out.
Note: If you have the Winshuttle function module installed on your SAP server, you can maintain the query time-out centrally in the table /WINSHTLQ/QREPRM. If you set this value both on SAP and on the QUERY client, the lowest duration of the two is chosen. For more information about setting the time-out in /WINSHTLQ/QREPRM, see the Winshuttle function module documentation.

Changing the admin options password

To change the admin options password

Select Change Password.
Type your old password.
Type your new password. Type the new password again to confirm.

Editing SAP authorization objects in QUERY

When you work with an SAP system that does not have the QUERY function module installed, you must add the authorization objects for each user so that organization level security is maintained. You can edit or delete the authorization objects from within QUERY.

To edit authorization objects

Click the Edit SAP Authorization Objects link.
In the Authorizations pane, locate the object you want, and then click Edit.

To delete an authorization object

In the Authorizations pane, locate the object you want, and then click Delete.

To add a new row for a new authorization object

Click Add a new row.

Adaptive Query Throttling

The administrator must give permission for this setting to be available to users. The user setting appears in the Advanced Run Options pane. In addition, the Winshuttle Function Module must be available on the SAP system where Adaptive Query Throttling is used.

Using a patented algorithm, QUERY adaptively throttles the execution of the query on the SAP server based on the current load on the SAP server. The available server resources are calculated from the total number of open dialog processes. When over 50 percent of the dialog processes on the SAP system are available, the query is executed at full speed, but when the available server load starts falling below 50 percent, the execution of the query is dynamically slowed.

Adaptive throttling addresses the performance concern around querying on a live transactional system that query execution could take substantial computing resources that might compete against regular SAP transactions, and adversely affect the performance of these transactions. QUERY addresses this issue by allocating only available compute resources to execute queries in the live SAP system.

The graph below shows the query performance time against the system load with and also without the adaptive query throttling algorithm applied. When the throttling algorithm is applied, query execution slows as the system load increases; however, without the algorithm, the query executes in constant time and competes for resources with other transactions on the system.

Note: Although disabling this option while running the query can improve the query performance, the risk is that it can bring down the server when it is already overloaded. Hence, we recommend that you always run queries with this option enabled unless it is ensured that the SAP server is not highly loaded.

Mismatched queries can be processed only when Adaptive Query Throttling is enabled. However, your returns for run, preview, and number of entries may differ from the results obtained through a direct run through SQL. Data types and padding may alter results.

Also in this section

Authorizations