Can we pull the filters used in OTBI Analysis?

Question

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.

Regards,

Aruna Aounti

Anders W. Langholm · Answer

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)

Anders W. Langholm · Answer

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":

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

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

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

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:

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