OBIEE does not recognize joins anymore — Oracle Analytics

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 does not recognize joins anymore

Received Response
1
Views
3
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

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

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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?

  • Joel
    Joel Rank 8 - Analytics Strategist

    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.

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

    +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