OBIEE 10G/11G - Direct Database Request

Saw Object


The Direct Database Request permit you to perform SQL statement directly to a datasource. The Oracle BI Server sends unprocessed, user-entered, physical SQL directly to an underlying database. The returned results set can be rendered in Oracle BI Presentation Services, and then charted, rendered in a dashboard, and treated as an Oracle BI request.

Becareful, you can perform SELECT but also CREATE or even DELETE and DROP statement!

You bypass completely the OBI Server mechanisms such as :

You can use it to perform complex query such as using a table function.

How to create a Direct Database Access ?

Access to Direct Database Access


Click on answer and you should see a link in the subject area. (If not see the security paragraph below)

Obiee Database Request Subject Area


In the global header, select New, then Analysis, then Create Direct Database Request.


Enter :

  • the connection pool
  • the sql statement

You can find the name of the connection pool in the Oracle BI Repository in the physical layer.

Obiee Connection Pool

Obiee Database Request Answers

You can use in the SQL statement a variable. Below, a example with a presentation service variable with a default value of 'Photo'.

How to

Call a database Function


Obiee Jdbc Odbc Function Direct Connection

Database Request in Dashboard

Add a prompt in the dashboard to update the presentation service variable and the Direct Database Request can be filtered.

Obiee Dashboard Database Request

And the download link works perfectly and gives you the filtered data (Tested on version

Security, Privileges

OBI Presentation Service

You must grant your account with the privilege “Write Back to database” :

  1. Login in OBI Presentation Service Website
  2. Follow this links : Setting / Administration / Manage Privileges
  3. Grant the privilege Answers/“Execute Direct Database Requests” to the permitted group

Administration Tool

You must grant the direct access database to the user through the Administration Tool in the security part.

  1. Login in OBI Administration
  2. Go to the menu : Manage / Security
  3. Grant the privilege “Execute Direct Database Access” to the permitted group of user



ORA-00911: invalid character at OCI call OCIStmtExecute

Be careful that you have to suppress the semicolon at the end of the statement.

[nQSError: 27022] Unresolved Connection Pool object: ….. (HY000)

Be sure to have the name of the database and the name of the connection pool framed by two doubles quotes.


database."Connection Pool"

is not good whereas

"database"."Connection Pool"

is good.

Discover More
Obiee Period To Period Comparison Lag
Blog - Obiee 10G – Period to period comparison with the analytical function Lag/Lead

During this thread on the Obiee forum, Goran point out a solution for a period to period comparison...
Obiee Database Object
OBIEE - Database Object

The database object in the physical layer of the three-layer metadata model. Database define the default features of the database. The virtual Private Database check box identifies the physical...
Obiee Direct Db Number Piplined
OBIEE - Table Function/Stored Procedure in Direct Database Request

How to use a table function with the direct database request Then in the direct database request add this statement When you use a table function, you may have the surprise to see that BI...
Obiee Presentation Variable Formula Column
OBIEE - Where can I use a presentation variable ?

You can reference presentation variables in the following areas : Answers : Title Views Narrative Views Column Filters Column Formulas Conditional Formatting conditions Chart scale markers....
Saw Object
OBIEE 10G/11G - Answer/Analytics

(Answers 10g|Analyses 11g) is the base component of BI Presentation Service to create Web report . It provides: ad-hoc query and analysis capabilities. The definition of an answer is principally...

Share this page:
Follow us:
Task Runner