Complex join

What is a Complex join?

A Complex Join in used in the Business Model & Mapping Layer (BMM layer) in the repository. Logical tables in a BMM layer can have multiple logical tables sources (LTS). Complex join actually is an intelligent join between LTSs of two logical tables in BMM Layer. When two columns are selected for a query in Answers/Dashboard, BI Server reads the complex join between two logical tables and then intelligently & dynamically selects the LTSs to join. This means that the BI server is able to select the most efficient join in the physical layer and translate query into a physical SQL.