nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Extract all the SQL queries of different BI Publisher reports

Sherazad Melili

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.

Find more posts tagged with

SQL

BI Publisher

Accepted answers

Mallikarjuna Kuppauru-Oracle

Hi @User_JX3W3

My suggestion is to log an Idea's lab Request for your business case.

@Ashish Shrivastava-Oracle

Regards,

Arjun

All comments

Mallikarjuna Kuppauru-Oracle

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

Sherazad Melili

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

Mallikarjuna Kuppauru-Oracle

Hi @User_JX3W3

My suggestion is to log an Idea's lab Request for your business case.

@Ashish Shrivastava-Oracle

Regards,

Arjun

Upcoming Event

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…

Top Leaders