Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to exract SQL statements applied to BIP reports

Submitted
11
Views
3
Comments
NagarajuKanukanti
NagarajuKanukanti Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence Idea Lab

At our organization, we would like to execute various scans on the SQL statements applied to BIP reports, for style, defect-checking, security, and more. The SQL is embedded in BIP report packages are in a binary format. We are looking for recommendations on how to extract the SQL statement code, which we can then send as input into one or more tools for scanning.

Tagged:
3
Up
3 votes

Submitted · Last Updated

Comments

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    This will be a great enhancement. Currently, in our organization, we are replacing one the existing fields with a new one and we have to scan through all the reports one by one. If we can get to extract the SQL statements, it will definitely help a lot.

    Upvoted.

    Thanks.

  • Daan Beumer
    Daan Beumer Rank 2 - Community Beginner

    Agreed, this will be most helpful for our customers as well to ensure the quality of the reports across the board.

  • User_NELUO
    User_NELUO Rank 1 - Community Starter

    This will be a good to have tool