Iam working with Database Direct Request to execute a stored procedure. When I hav given the commad and clicked on 'Validate SQL and Retrieve columns' it is showing all the columns below. But when I click on "Results" tab it is giving me an error like
"Error generating view. You don't currently have the necessary privileges to execute Direct Database Requests"
I logged in to OBIEE (Web) as an 'Administrator'.
What other permissions do an Administrator need in order to resolve the above issue?
Try with Evaluate function
http://oracle-bi.siebelunleashed.com/articles/callingdb-function-in-obiee/ Syntax for Evaluate function in OBIEE
Check connection pool- properties -- there you can call your procedures
Edited by: MK on Jan 20, 2012 3:39 AM