Bookshelf Home | Contents | Index | PDF     

Siebel Analytics Web Administration Guide > Working with Data and Managing the Web Catalog Using Siebel Analytics Web SOAP API > Description of Methods in the Siebel Analytics Web SOAP API >

Retrieving the SQL for a Report Using the generateReportSQL() Method in the Siebel Analytics Web SOAP API

The generateReportSQL() method in the ReportEditingService service retrieves the logical SQL query for a given report.

Description of Parameters in the generateReportSQL Method()

The generateReportSQL() method parameters are described in the following table.

Parameter
Description

ReportRef reportRef

The path to the report definition supplied in the ReportRef common structure. For more information, see Referencing a Report Using the ReportRef Structure in the Siebel Analytics Web SOAP API.

ReportParams reportParams

The path to the filters or variables to apply to the report before execution, supplied in the ReportParams common structure. For more information, see Replacing Filters and Variables in a Report Using the ReportParams Structure in the Siebel Analytics Web SOAP API.

This parameter is optional.

String sessionID

A character string that identifies the session ID.

The session ID is usually returned by the logon call. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null.
    
Siebel Analytics Web Administration Guide