Siebel Analytics Web Services Guide > Description of Siebel Analytics Web SOAP API Methods > ReportEditingService Service >

generateReportSQL() Method


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

Signature

String generateReportsSQL(ReportRef reportRef, ReportParams reportParams, String sessionID);

Arguments
Description

ReportRef reportRef

The path to the report definition supplied in the ReportRef common structure. For more information, read ReportRef Structure.

ReportParams reportParams

Optional. The path to the filters or variables to apply to the report before execution, supplied in the ReportParams common structure. For more information, read Description of Siebel Analytics Web SOAP API Methods.

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.

Returns

A string containing the SQL query for the specified report.

Siebel Analytics Web Services Guide