How to exract SQL statements applied to BIP reports — Oracle Analytics

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
12
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