Winshuttle Central Query menu: Preferences (Query)
Query menu topics
The preferences page enables you to configure a variety of options for your client users. You can do things such as:
- Enable or disable the ability to locally schedule a Winshuttle Query script with an Excel data source.
- Enable self-approval
- Require approvers to enter a reason if they reject a submitted Winshuttle Query script.
On this page
- Changing preferences
- Desktop Scheduling preference descriptions
- Site preferences descriptions
- Account preferences for Query Output
Back to top
- From the Winshuttle CENTRAL Administration page, under QUERY, click Preferences.
- Select (or de-select) the option you wish to enable (or disable).
- Under Preferences (at the top of the page), click Save to apply your selection.
When checked, each of these 4 options (XML, Excel, Access, Text) enables users to schedule runs locally.
Select the check box for the data source types that can be run locally (Excel, XML, Access, or Text).
CENTRAL Mandatory FieldsBack to top
Query Script Rejection Reason Required determines whether or not it is mandatory for reviewers to provide a reason for rejecting the QUERY script files. Select (check) to require a reason for script rejection.Back to top
Data Dictionary Users
Data dictionary users who are not administrators can only search the available Winshuttle dictionary. When a new version of the data dictionary is available, it is automatically downloaded from the server when the user opens QUERY.
Select this option so that everyone should use the centralized data dictionary.
Allow Self Approval
Checking this option allows file creators to approve their own files.
QUERY Script Approval
This option specifies whether or not QUERY script files require approval.
If this setting is not selected, when a file is submitted it immediately becomes a production file. No review is required.
Controlling string padding
Padding, also known as leading zeros, is applied by default for NUM, NUMC, Char, and string data types.
If a user compares non-numeric data without padding, the results may be unexpected. Check the box to enable string padding.
Enabling Adaptive Query Throttling
Users apply query throttling by selecting a check box in the Advanced Options window of QUERY. However, an administrator must first enable throttling in CENTRAL.
Using a patent-pending 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 address 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 run queries in the live SAP system.
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.
Centralized Data Dictionary
With CENTRAL, you can allow each user to maintain his or her own data dictionary, or you can provide one data dictionary for all users that only a data dictionary administrator can add tables to. By default, each user has his or her own local data dictionary. The centralized data dictionary must be specifically enabled. With a centralized dictionary, users can still assign favorites from the existing tables, but these local favorites are not written to the server.
A data dictionary administrator can create or edit a dictionary and upload it to the CENTRAL SharePoint site. An administrator can edit a local copy or download the latest copy from the server. Administrators can search for and add tables within both the Winshuttle data dictionary and the SAP data dictionary.
To apply a centralized data dictionary, you must have the data dictionary administrator role. The data dictionary administrator is assigned on the Central Roles by User page. You must already have a developer role before you are assigned the data dictionary administrator role.Back to top
Note: This option is available in Central 10.6+ only.
This option lets you specify which type of account you want to use for Query output to a SharePoint List. 2 options are available:
- App Pool Account. This is the same account under which the winshuttle worker service is running.
- System Account. The System Account can be any user account with Administrator privileges and a password never expires.