Adding tables

When you open the Business Cube - Join Editor, you will see all the tables (including views) that have been added to the business cube when you create it. If you find that you require some extra tables to create joins, you can add them as follows:

  1. In the Business Cube - Join Editor window, click Table > Add Table to display the Add Table dialog.
  2. Select a schema from the Schemas box if the database supports schema. The tables that are contained in the selected schema and are not included in the business cube will then be displayed in the Tables box. Choose the required tables, and then click the Add button.
  3. Click the Done button to close the dialog. Then, all the selected tables/views will be shown in the right panel of the Join Editor window.

  4. Click the Arrange button to organize the tables.

Now, you can define joins among the selected tables as required.

Tips: