Siebel Analytics User Guide > Basics of Working with Requests in Siebel Answers >

Examining or Editing the Logical SQL Generated for a Siebel Analytics Request

This section explains how to examine or edit the SQL or XML generated for a request.

NOTE:  This procedure is only for advanced users and developers that have the appropriate responsibilities to access the Advanced tab. It is assumed that you know advanced SQL, have expertise working with the Siebel Analytics Server metadata, are familiar with the SQL information in Siebel Analytics Server Administration Guide, and understand the content and structure of the underlying data sources.

For example, you can edit the logical SQL for a request when the underlying presentation objects have been changed, instead of re-creating the request. For details, see the topic on migrating changes to Siebel Analytics requests and filters in Siebel Analytics Web Administration Guide.

The Advanced tab also provides access to links that you can use to execute saved requests from an external Web page, portal, or application. When you click the Advanced tab for a saved request, the section Referencing the Results appears. It contains the links and provides instructions to use them.

To examine or edit the XML or SQL generated for a request

1. In Siebel Answers, create or modify a request and click the Advanced tab.

   The proposed XML and logical SQL appear for the request.

2. Use the Advanced SQL Clauses section following the proposed SQL to change the subject area, add GROUP BY or HAVING clauses, and specify DISTINCT processing.
3. To combine this request with a similar request from the same subject area or another subject area, where you can perform Set operations such as UNION or INTERSECT on the results, click the following button on the Criteria tab:

   Combine with Similar Request

   If you want to edit the SQL or XML directly, continue with the following steps.

   CAUTION:  When you click the Set SQL button in the next step, be aware that the Criteria tab for this request may no longer be accessible.

4. If you want to modify the SQL, read the preceding caution statement, make your modifications to the SQL directly in the Edit window, and then click the Set SQL button.

   CAUTION:  Requests are stored in the Web Catalog in XML format. If you change the XML in the following step, you are changing the request in the Web Catalog.

5. If you want to modify the XML, read the preceding caution statement, make your modifications to the XML directly in the Edit window, and then click the Set XML button.