Here is an example of a warning from my consistency check: Warning: [38100] The logical tables "Core"."Inventory" and "Core"."Dept Budgets" connected by logical join '"Relationship_2004:6243231247724664"' have no corresponding physical connections.
Analysis: There are 74 of these warnings in the consistency check. Most of them are as clear-cut as the example above. It is obvious that there would be no business reason to link departmental budgets with product inventory. If an author should build an analysis with columns from these two unrelated tables, that analysis would return an error, and rightly so.
As far as I can tell, nothing will be harmed by removing this logical join, because it doesn't make any sense to begin with, and OBIEE can't create an analysis containing columns from these two tables because they aren't connected in the physical layer.
But why does this logical join exist at all? This RPD originally was delivered with EBS. I am pretty sure that my client didn't go to the trouble of joining unrelated logical tables. Why would the EBS RPD contain logical joins between unrelated tables?
