nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

which table stores the details of OTBI analysis Filter Criteria/conditions

Besta Narayana Swamy Prasanth Kumar

Hi Team,

We have a requirement to extract the OTBI analysis filter criteria details using bi report to understand the conditions present in the analysis is created.

These details are required to understand the selection Method of learners in a Learning Access Group.

Please share if anyone has details around this.

Thanks in advance!!

Prasanth Besta

Find more posts tagged with

Reporting

BI Publisher

OTBI

Accepted answers

Nathan CCC

Hi Prasanth,

The answer is NO table. In OTBI your analysis is a file in the BI catalog on the middleware application server hosted in your SaaS. The metadata definition of your analysis is XML. You can see the XML on the Advanced tab when you edit your analysis. This XML is not written to a database table.

FYI There are some data from OBI in its metadata S_NQ_* database tables created at install time in a database. This is used for runtime logging for example usage tracking statistics and scheduled agents run error messages etc. But that is it. The catalog is not stored in a database.

I think you are saying you want to loop around each analysis in your catalog looking for something in the conditions in the where clause in the logical SQLs? Possible you can use the OBI web service WSDL to read the analysis metadata. Or possible you can unarchive your catalog to a local machine empty OBI install so that you can use the middleware bi NQ command line tools or maybe host operating system command line tools like just good old grep or something to read your analysis metadata to search for some sort of pattern.

gclampitt

Another option is you can use usage tracking ie "OTBI Usage Real time" subject area which will return the Logical SQL which will then tell you the filters used in the reports that have been run.

All comments

Sumanth V -Oracle

@Besta Narayana Swamy Prasanth Kumar - Your query is on the OTBI please contact the OTBI Team for accurate response.

@John Hung-Oracle - Kindly assist by moving this thread to OTBI community. Thank you!

John Hung-Oracle

Moved to OTBI forum

Nathan CCC

Hi Prasanth,

Besta Narayana Swamy Prasanth Kumar

Hi Nathan,

Thanks for the update and more details, this helps.

Regards,

Prasanth Kumar

gclampitt

Another option is you can use usage tracking ie "OTBI Usage Real time" subject area which will return the Logical SQL which will then tell you the filters used in the reports that have been run.