Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Can we pull the filters used in OTBI Analysis?

Received Response
32
Views
2
Comments
Aruna Aounti -Oracle
Aruna Aounti -Oracle Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Hi

We are searching for the feasibility/way to pull the filters used in the OTBI Analysis thru BI report or any other way.

Please find the screenshot.

image.png

Regards,

Aruna Aounti

Answers

  • Anders W. Langholm
    Anders W. Langholm Rank 5 - Community Champion

    It's a bit complex, you need to find the physical sql behind the analysis.

    I have created a very simple example from Payables Invoices - transactions real time, where I just want all invoice type code that are equal to "STANDARD":

    image.png

    Once the analysis is done, I click on Administration and find Manage Sessions under Session Management:


    image.png image.png

    Here you go and look for your analysis and click "View log":

    image.png

    The log can be overwhelming, but you need to look for the last sql that starts with a with-sentence:

    image.png

    You copy that and paste it into notepad++ or a sql-tool and then you just go hunting for your values and try to trace them back to where they origin from:

    image.png

    In your case, I would start by searching for 0621 and see what it gives you 😉

  • Anders W. Langholm
    Anders W. Langholm Rank 5 - Community Champion

    Or perhaps you just need to see the mapping of the subject area that the filters origins from and search for the name and see what the table and column-name is from there :

    List for all OTBI subject areas/dimensions (as of 23C) — Cloud Customer Connect (oracle.com)