Delay in BI reports showing up

We had a direct database request in BI answers. When user click on report to see the output, BI was taking unusually long time just to show the clock to indicate query is working.

We found out, it the option ‘Bypass Oracle BI Presentation Services Cache’ that was adding a long delay. It wasn’t required, so removing it made the report work just fine.

Direct Database Connection error

We created a direct database connection, and it worked fine when tested as Admin. But when I was trying to give a end user access to that report, it kept throwing access denied error:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 13017] User or group has not been granted the Direct Database Access privilege to access the database 'Oracle Data Warehouse'. Please verify the User/Group Permissions in the Oracle BI Administration Tool. (HY000)


I checked the permissions, and user add access to both:

Edit Direct Database Requests

and

Execute Direct Database Requests

Finally the problem was fixed by making a change in RPD. Do following if you are facing same problem:

-In the physical layer, click on database for which you need to enable direct database query for non-admin users (thats the green cylinder icon).
-Check option - "Allow direct database requests by default"

Thats it. It should work now.