Circular Joins
Circular join is a type of join that comes into picture when columns from more than 2 tables are used to create a report. An alert will be displayed when columns are dragged and a choice to choose between the available joins is displayed.
For illustrative purposes, three tables are used here. As observed in the below image, the third table (Order Details) is joined both ways with the first (Customers) and second table (Employees). Also, observe that the Customers table is in a one way join to the Employees table.
During the create report process, by dragging and dropping a column from a table, the user will be able to view all the tables that are joined to the initial table. Tables that are not joined to the initial table will not be displayed.
The third table (Order Details) here forms a circular join resulting in the formation of unintended extra joins that will narrow down the input data in the final report output. To avoid this situation, the user will be informed about the presence of a circular join and given a choice to choose the required join to resolve the issue. Choose a table and click OK.
The user can switch off the circular join alert from the report settings and admin user settings page.
By default, the option selected at the report level is Default. The user can turn it to On. By selecting Default the user is reflecting the option chosen at the Admin level.
