Complex folders contain items from one or more base folders. It is same like a view in database. It enables you to create a combined view of data from multiple folders. A base folder can be any of the following types of folder: a simple folder, containing items based on columns in a single database […]
About Discoverer: Discoverer is the end user adhoc query, reporting and analysis tool, which provides quick development environment to develop Data Warehousing & Business intelligence reports. What is business intelligence? Business Intelligence is the ability to analyze data to answer business questions and predict futures. Features and Benefits: Automated Summary Management – improving query performance […]
All discoverer folders and workbooks that you create get stored in database. You can use the below queries to find the details. Find your Discoverer Workbook and Folder Details from Database: select fu.user_name owner, doc.doc_id “Document Id”, doc.doc_name “Document Name”, doc.doc_developer_key, doc.doc_folder_id, doc.doc_created_by, doc.doc_created_date, doc.doc_updated_by, doc.doc_updated_date, min(qs.qs_created_date) first_acc, max(qs.qs_created_date) Last_Accfrom disco_apps.eul5_documents doc, apps.fnd_user fu, disco_apps.eul5_qpp_stats […]
Oracle Business Intelligence 10g Release 2, a key component of Oracle Application Server 10g Release 2, is an integrated business intelligence solution supporting intuitive ad hoc query, reporting, analysis, and web publishing. Discoverer 10.1.2 is tightly integrated with Oracle E-Business Suite Release 12. Release 12 users can use Discoverer to analyze data from selected business areas […]
How to run Discoverer Reports in Multi-Org Environment? When you are working in R12 MOAC environment, sometimes discoverer reports which are based on some context based view will not give data. Then do the following setup to make the discoverer reports work in MOAC environment. 1) Create a Security Profile in HR 1) Run concurrent […]
Recent Comments