Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 284 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 109 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE does not recognize joins anymore
Hi
I am using OBIEE 12c and till today my reports were working,
but today for every report it says that ther is no data.
I tried to make a new analysis and when i put one column next to another it says no data.
I even uploaded rpd from backup because i thought maybe i ve done something wrong today, but same issue occurs.
When i place only one column it reads the data but its like it doesnt recognize joins anymore.
I checked the data in the database, double checked joins in rpd, restarted BI server no ideas any more.
Plese help...
Answers
-
Hi,
turn your diagnostics up, run a query, look at the log and the physical sql therein.
Try running the physical sql directly against your database.
Does that give you any clues?
Also, do you have any row level security applied which could be failing?
0 -
As @Robert Angel mentioned above, check your logs, see if there are any pointers in there and if all else fails, sounds like a justification for a backup policy. I think you should retrieve a backed up rpd and verify if the same issue occurs.
0 -
+1'000 look at the logs. Look at the queries generated. Run the queries against the source. Check whether you have messed up cache. Etc etc etc
0
