Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Other user can not see the data from the workbook

365810Sep 23 2005 — edited May 21 2006

Hi Friends,

I created a workbook with some worksheets in a Business area. The owner of the workbook has no problem to view all the worksheets and get all the data returned.. I granted all the neccessary privileges to other users ,they could see the workbook, but no data returnd for the query results. Tried refresh the worksheet, same no data retrieved.Checked the SQL inspector and the plan, it showed the correct paths and execution plan without any errors there. The same query run in SQL plus by other users returned data correctly.
By the way, I had a summary folder in the workbook. During the troubleshooting, I dropped this summary folder, still the same no data return for other users.

Any body happen to know the cause or has some ideas on this issue?
The discoverer administrator verson is 9.0.4.00 and the PLUS /Viewer is 9.04.45.02.

Thank you very much,

J.K

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2006

Added on Sep 23 2005

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

15 comments

1,487 views