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

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

Accepted answer
52
Views
5
Comments
Besta Narayana Swamy Prasanth Kumar
Besta Narayana Swamy Prasanth Kumar Rank 1 - Community Starter
edited Oct 30, 2024 3:07PM in Oracle Transactional Business Intelligence

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

Tagged:

Best Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Oct 30, 2024 3:43PM Answer ✓

    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
    gclampitt Rank 6 - Analytics Lead
    Answer ✓

    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.

Answers