QUERY > Approving and rejecting files > Sending a file for approval

Back to

Approving and rejecting files

Sending a file for approval

After you create your query file, you can send it for approval. QUERY provides a wizard to guide you through the process for submitting a file for review. You can submit Microsoft Excel files, Microsoft Access tables, XML and text files, and SharePoint lists for approval.

To submit a file for approval

Approving your own queries

If you have a developer role, and if self-approval is enabled by the administrator, you can run files on a nonproduction server without submitting them for approval.

System usage level

When you submit a query file for approval, you can apply a system usage level to it. The system usage level describes level of system resources that a query might consume during a query execution. A system usage level is also assigned to the policy that is assigned to your user name, and controls the level of queries that you can run on a server at a given time. If the usage level of the script does not match the usage level of the policy that is assigned to your user name for a given time, the script cannot run at that time.

Because a policy system usage level setting also contains a specification for Maximum Number of Result Rows, a conflict could arise with the maximum number of records that can be downloaded, which is set in CENTRAL. If a conflict arises, the most restrictive setting is used.

In the CENTRAL pane, you can click the System Usage Level link to see the assigned usage level, the maximum number of records that can be downloaded, and the time out setting for the policy assigned to the user name that is currently signed in to QUERY.

Step 1. Complete Query File Information

A query file describes the information that you want to download from the SAP database.

Complete the file description information, the location on the CENTRAL server where the query file, and the system usage level for the file.

Step 2. Input Document Information

The input documents include the text files that are constant input files. They are used in the WHERE clause builder.

The wizard can display multiple input documents, but if two files have the same name, the name of one must be changed in the wizard.

When no input files are included in the query, the Input Document page is not available.

Step 3. Complete Data Template Information (Optional)

The query file can be embedded in an Excel file before it is submitted for review. You might want to embed the query in an Excel template if you plan to distribute the query to business users.

The Template required box is selected by default. If you clear the Template required check box, the query is submitted for review without an Excel template.

The Complete Data Template Information page is available only when the destination type is Excel.

Step 4. Complete Supporting Document (Optional)

Supporting documents include extra scripts, data sheets, or any other files that explain what you are submitting for approval.

Step 5. Complete review process information

Select the file reviewer and the due date for the review. Add any comments about the review.

Summary: Submit

On the Summary page, you can edit any of the previous pages. When the wizard is completed, click Submit to send the file for review.

After the file is submitted, it has a Review Requested status. The assigned reviewer is notified by an e-mail message and the file name appears as a task under the reviewer's Most Recent Files and Favorites.

Also in this section

Approving, rejecting, and reassigning query files