Most of my OBIEE report is taking longer time to load and then would not load at all. Table indexing everything is already done.. Kindly suggest how can i improve the report performance.
Before to try to improve something you must identify what you are supposed to improve.
"Improve report performance" doesn't actually mean anything in OBIEE as the report performance is a mix of multiple applications talking to each other, so until you don't start by finding out where time is spent there is nothing to improve (sorry but the GO_FAST = 42; parameter in nqsconfig.ini doesn't work ...).
If you want to start analyzing the root cause of your poor performance have a look at this: https://www.youtube.com/watch?v=0W34l2O9GMo
And the slides @rmoff wrote are here: No Silver Bullets - OBIEE Performance in the Real World (Oracle Open …
Thank You!!
Actually when i ran the physical query of the report taken from Manage Session. It took almost a day to fetch the data and also fetched only 17 records.
Tables used in the query is already indexed. Kindly suggest how to fine tune the query.
Indexing means nothing if not done with regards to the actual queries run against the database.
As Gianni said unless you do a proper analysis there's no "one size fits all" solution.
Well, this doesn't really tell you where the issue is ...
Did the query take a day to return you 17 records because your DB is slow or did it take so long because the query was really bad?
If it's the first you must ask a DBA to have a look and it's a DB issue, if it's the second you must investigate if the report is written in the best possible way, if the model in the RPD can be done in a different way etc.
So you need to look a bit more to find out exactly where to spend time improving something getting the best improvement out of it (like the 80-20 rule: find where you can improve 80% by investing just little time).
query is taking lot of time, DB is not slow. and please suggest how to redesign the RPD model for that particular report. Because the presentation , logical and physical tables and joins are already created ..How to proceed , so that i can check whether it is the query problems or join ?
3010666 wrote: ... and please suggest how to redesign the RPD model for that particular report ...
You know that we have no idea of what kind of report you are talking, right?
Did you watch the recording of "No Silver Bullets - OBIEE Performance in the Real World" @rmoff did? Or at least reading the linked slides?
There you find all the inputs to do a proper analysis of what happen when you run your analysis.
3010666 wrote: ... DB is not slow...
Who told you that? What does "slow" for a DB mean for you? Again without an analysis of where time is spent, without a "time profile" of your analysis it's impossible to say if it's a query problem, a join or just because today it's sunny or windy ...
This video is no longer available. This slide sharge no longer exists,
@Edward Camarillo , well … they were there 8 years ago… (yes, this doesn't help you). It was external content (not Oracle owned), the author/owner moved on and the content has been removed.
If you are facing a problem, you could maybe post a new question describing the situation (including product names and version), and what kind of information you look for.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
