Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Get privilege to issue logical SQL in OTBI — Cloud Customer Connect
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

Get privilege to issue logical SQL in OTBI

Accepted answer
23
Views
2
Comments
edited Sep 11, 2019 10:17AM in General Transactional Reporting (OTBI) 2 comments

Summary

As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log for diagnostics like physical sql

Content

Hi,

Does anyone know if in Oracle Cloud Application, we are oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0), does a role exist that has been granted privilege "Admin:General"/"Issue SQL Directly" by person with bi administration privileges who went to the Administration menu then the page "Manage Privileges" to assign that privilege to a role. Our development team who are writing extensions using oracle transaction business intelligence (OTBI) real time subject areas, to be productive, need the ability to issue logical sql, view results with the log level set > 0, then view the log file with rich diagnostics like timings and row counts

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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