You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to find global SQL on bi publisher

in Transportation Management 1 comment

Summary:

Following an issue with report execution in BI Publisher, I recall that one of your consultants (Ahmed) showed us how to retrieve the query built by the Oracle code when running a report in BI Publisher that references multiple datasets. Could you please tell me how to retrieve this query? I've used the buttons directly in Publisher, and I've also enabled some logging in the log files, but this only gives me the queries separately, not the overall query. Thank you for your help.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!