您当前没有执行直接数据库请求的必需权限

 

 

 

http://forums.oracle.com/forums/thread.jspa?threadID=511547

 

View Display Error
Error generating view. You don't currently have the necessary privileges to execute Direct Database Requests.
Error Details
Error Codes: OAMP2OPY:Q4NU7XSN
Invalid Handle Of 'class saw::NQWebView *' Exception

 

 

解决方案：

 

You can do this by logging into the Presentation services as the Administrator user. Clicking on the Settings tab and then selecting the Administration option. On the Oracle BI Presentation Services Administration window select the Manage Privileges option. This brings up the Privileges Administration window, scroll down to the Answers section (listed on the left) and check the Execute Direct Database Requests privilege setting this is defaulted to let no one execute Direct SQL request. Reset the privileges such that the group that the user trying to execute the direct database request belongs to is set to be able to execute the direct database requests. This should alleviate the error that you are getting.

 

 

 

总结：

1、BIEE安装后默认是不开放执行直接数据库请求的。

2、一直纠结在编辑直接数据库请求上，竟然没看到最后一项，老眼昏花了啊。。

 

 

 

终于显示出来了。。杯具。。。