How to create a report out of two databases in OBIEE?

You have 2 options:
1) RPD level: bring those 2 tables to BMM layer into one Business model and then put them in the same catalog in presentation layer.
2) Answers level: Use combine with similar request and create the report.

Until Next Post... :)