Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Script for Discoverer Report Names??

Hi friends,
We are trying to Extract the discoverer Scripts, from application but it is taking too long time in order to achieve this and even Tool is responding slow.
Please provide query to find out discoverer report name is assigned to which responsibility and user(we are able to view the all folder names)...??? So that we can Navigate to particular responsibility and take scripts
We are using :
OracleBI Discoverer 10g (10.1.2.3)
Thanks in Advance....
Answers
-
Please reply me Anybody as this didn't got solved yet...??
-
SELECT ba.ba "Business_Area",
usr.user_name,
doc.doc_name "Work_Book",
MIN (qs_act_elap_time) "Fastest",
MAX (qs_act_elap_time) "Slowest",
ROUND (AVG (qs_act_elap_time), 2) "AVG_secs",
ROUND (AVG (qs_act_elap_time) / 60, 2) "AVG_mins",
COUNT (*) "Often",
doc.doc_created_date,
MIN (acc.qs_created_date) "First",
MAX (acc.qs_created_date) "Last_Access"
FROM eul5_documents doc,
apps.fnd_user usr,
eul5_qpp_stats acc,
(SELECT DISTINCT gd_doc_id
FROM eul5_access_privs) privs,
(SELECT DISTINCT doc.doc_id, ba.ba_name ba
FROM eul5_documents doc,
eul5_elem_xrefs eex,
eul5_ba_obj_links bol,
eul5_objs obj,
eul5_bas ba
WHERE doc.doc_id = eex.ex_from_id
AND eex.ex_to_par_name = obj.obj_name
AND obj.obj_id = bol.bol_obj_id
AND bol.bol_ba_id = ba.ba_id) ba
WHERE '#' || usr.user_id = doc.doc_created_by
AND doc.doc_name = acc.qs_doc_name
AND privs.gd_doc_id = doc.doc_id
AND usr.user_name = UPPER (acc.QS_DOC_OWNER)
AND doc.doc_created_date < acc.qs_created_date
AND doc.doc_id = BA.doc_id
GROUP BY ba.ba,
usr.user_name,
doc.doc_name,
doc.doc_created_date;
-
Thankyou for your response.
-
the table eul5_access_privs resp information to pull workbooks list .