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

OBIEE 12.2.1.3 dashboard different run times each time

Received Response
41
Views
5
Comments
User_INLWQ
User_INLWQ Rank 5 - Community Champion
edited Aug 13, 2024 5:13PM in Oracle Analytics Cloud and Server

Hi Obiee forum

New to this obiee/reporting softwares, i setup a dashboard with multiple reports, gave a value in prompt and tried running it. At different times it is taking different durations to show results. Say 9 mins, 19 mins, 38 mins etc.

User is not happy with this, please suggest how to start looking this issue and fix performance.

Thx in advance...

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Before to fix "performance", you should find out of there is a performance issue (sometime things are slow because of what you ask, not because of poor performance).

    Look at the logs and start analysing what the tool does (how long is spent on what, and what actions are performed etc.).

    OBIEE doesn't have a simple setting for performance, the platform does various things depending on how you did build the analysis and the models, so you have to really go through logs.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1000 to Gianni. There's no magic "run faster" or PERFORAMNCE_MODE=ON config option. Neither in Analytics nor in any dta source you're based on.

    Where does the performance loss actually happen? Presentation server? BI Server? Data source? What are you doing / processing what? etc. etc.

    There are 500 questions and only you, sitting in front of the topic, can analyze the logs and the artifacts to start getting insights.

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    Did you give up on this?

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    Chris/Gianni,

    this dashboard is running against OLTP database (i am aware these BI/reporting tools are highly recommended to run against OLAP data warehouses). So wondering if there's a difference in tuning approach for OLTP vs OLAP sources in OBIEE...

    Thanks..

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Without logs there's nothing we can say.

    And also take three steps back and think about this: You're running against an OLTP? Why are you thinking "tuning approach" from the BI side - maybe the OLTP system is just overloaded at the time you're running your "report". And if the source database (OLTP) is slow what do you want to do? I can take Hamilton and have him sit into a Twizy Urban and ask him to make it run faster. It won't. :)