Setting up and editing joins

A report cube is based on a query, stored procedure, SQL file, or user defined data source, which may already contain some relationship among its tables. However, for a business cube, it is based on tables, and by default there is no relationship between the tables. In order to make them correlated, you need to define joins between them. To do this:

1. In the Catalog Browser resource tree, select the business cube, right-click it and select Edit Business Cube from the shortcut menu.
2. In the Business Cube Editor window, click Tools > Join Editor on the menu bar or the Join Editor button on the toolbar. The Query Editor window appears.
3. Add more tables to use in the business cube if needed and set up the joins between the tables, then click OK to save the settings.

   For more information, refer to Adding and deleting tables in a query and Joining tables in a query.