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);
|
|
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.
|