Oracle® Business Intelligence Web Services Guide > Description of Services in Oracle BI Web Services > ReportEditingService Service >

generateReportSQL() Method


Use this method to retrieve the logical SQL query for a given report.

Signature

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

Arguments
Description

ReportRef reportRef

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

ReportParams reportParams

Optional. Specifies 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 Services in Oracle BI Web Services.

String sessionID

Specifies the session ID, which is usually returned by the logon method. 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.

Oracle® Business Intelligence Web Services Guide Copyright © 2007, Oracle. All rights reserved.