Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

BI publisher: how to get query hitting database from a BI publisher report

Received Response
461
Views
3
Comments
User_INLWQ
User_INLWQ Rank 5 - Community Champion
edited Aug 13, 2024 5:20PM in Oracle Analytics Forum

Hi Gurus,

New to BI Publisher space. Wondering how to retrieve the query behind a BI publisher report.

We need to performance tune BIP reports so i would like to look at the SQL query if there is any chance to optimize it.

Thanks in advance.

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    Have you enabled BI Publisher logging? As you didn't mention your version, use this document to configure logging: https://support.oracle.com/knowledge/Siebel/2076111_1.html

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    Thanks Joel,  we are on 12c,  If possible kindly share word or pdf version of the link you posted as right now have no access to Oracle support account.

    Also i am trying to capture the query as performance is the main concern.  Report is taking 40 seconds to run which is unacceptable.

    Please also share any documents/tips on the performance too. (Already created JNDI source instead of JDBC,  used group by, checked "data already sorted" option,  but still performance is not as expected.

    Thanks again.

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    I'm afraid that you need an Oracle Support licence to access this document and as a result, I can't share this unfortunately.