Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Basics of Working with Requests in Oracle BI Answers >

Executing a Direct Database Request in Oracle BI Answers

Users with the appropriate permissions can create and issue a direct database request directly to a physical back-end database. The results of the request can be displayed and manipulated within Oracle BI Answers, and subsequently incorporated into Oracle BI Interactive Dashboards and Oracle BI Delivers.

The following permission settings in Oracle BI Presentation Services administration control whether you can create and issue physical requests:

• Edit Direct Database Requests

  If this permission is set for you, you can create direct database requests. By default, this permission is set only for users defined as Oracle BI Presentation Services administrators.

• Execute Direct Database Requests

  If this permission is set for you, you can issue physical requests. By default, this permission is not enabled for anyone. It can be changed by an Oracle BI Presentation Services administrator.

To execute a direct database request

1. At the Oracle BI Answers start page, click the following link:

   Create Direct Request

   The Criteria tab opens.

2. Follow the on-screen instructions to specify the name of the connection pool for the database defined in the physical layer of the Oracle Business Intelligence Server Administration Tool.

   For information about connection pools, see Oracle Business Intelligence Server Administration Guide.

3. Follow the on-screen instructions to create the physical request.

   CAUTION:  Oracle BI Server security rules are bypassed and cannot be applied when direct database requests are issued from Oracle BI Answers.

4. To bypass the Oracle BI Presentation Services cache, click the bypass option.
5. To issue the request, click the Results tab.

   The results, if any, are displayed in the workspace.