
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:
- In the Business Cube - Join Editor window, click Table > Add Table to display the Add Table dialog.
- 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.
-
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.
- Click the Arrange button to organize the tables.
Now, you can define joins among the selected tables as required.
Tips:
- Tables that have been added to a business cube can be deleted if not required. To do this, select the table in the Business Cube - Join Editor window, and then click Table > Delete Table. However, a table with a join to another table cannot be deleted.
- If you want to hide a table which is not a part of a join, click
in the upper right corner of the table. To redisplay hidden tables, in the Business Cube - Join Editor window, click Table > Table Properties to show the Table Properties dialog, then move the hidden tables from the Hide Tables box to the Show Tables box (you can also use this dialog to hide tables without join relations).
