Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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
444
Views
3
Comments
User_INLWQ
User_INLWQ Rank 5 - Community Champion
edited Aug 13, 2024 5:20PM in Oracle Analytics Cloud and Server

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
    Joel Rank 8 - Analytics 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
    Joel Rank 8 - Analytics 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.