I have two different fact tables with their corresponding dimensions.

Is it possible to put them in the same business model?

If I put both fact tables in the same business model and connect all of the relationships, my metadata layer publishes successfully. However, when I go to run a report, it creates a SQL query with incorrect joins and most of the queries that it produces do not complete successfully.

If I do not connect the relationships and leave them have two separate fact tables, I get the following error and the report does not run:

Code:
SqlGenerator.ERROR_0002 - Failed to find path between two business tables
Is it possible to have two different fact tables in the same business model?