Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Extract all the SQL queries of different BI Publisher reports
Sherazad Melili
Rank 1 - Community Starter
Hello,
I have many reports and I want to extract all the Sql queries of their data model. I can't do it manualy because I have more than 100 reports.
Can I find a way to do it automatically with a script or with administration please?
Thanks for your help.
Regards.
Tagged:
0
Best Answer
-
0
Answers
-
Hi @User_JX3W3
Thanks for using Oracle Communities.
I didn't see any option for automated way as per existing functionality & design. What is your business Purpose here to extract all queries?
Regards,
Arjun
0 -
hello @Mallikarjuna Kuppauru-Oracle ,
thank's for your answer.
The purpose is that we are going to change oracle hcm cloud to another solution , and we need to retrieve all the queries so we will need them to implement the new solution.
Thanks
Regards
0