OBIEE does not recognize joins anymore

Question

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...

[Deleted User] · Answer

+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

Joel Acha · Answer

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.

Robert Angel · Answer

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?