Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

Accepted answer
35
Views
3
Comments
Sherazad Melili
Sherazad Melili Rank 1 - Community Starter
in Oracle Analytics Publisher

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:

Best Answer

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    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
    Sherazad Melili Rank 1 - Community Starter

    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