After you create a business model you must add the business tables and business columns; then, you create the relationships between your business tables.
Up to this point, you have used the navigation pane to build the business objects. The workspace on the right side of the page is called the Metadata Editor Graph. Use the Graph to lay out your business tables and show the relationships between them. While you can accomplish the rest of your tasks by manipulating the objects in the navigation pane, you can also use the Graph.
To create business tables and columns...
- Right-click Business Tables in the navigation pane. Alternatively, you can right-click inside the Metadata Editor Graph workspace and select Business Tables.
Tip: Drag the physical table from the navigation pane to the Graph workspace to create a new business table based on that physical table. Another shortcut is to drag the physical table in the navigation pane to the Business Tables node, which will also create a new business table based on that physical table. A list of physical tables, each prefixed by the connection name to which they belong appears.
- Select the physical table you want associated with the new business table.
- Click OK to display the Business Table Properties dialog box.
In the Business Table Properties dialog box, the ID field is pre-populated with a value. This ID identifies a specific business table, and must be unique. Pentaho recommends that you accept the default value for this field.
The table you chose in Step 3 is listed next, then below the fields is another navigation pane, with the name of your business table and all the columns inherited from the physical table included as business columns. The business columns are created for you when the new business table is created, so no need for the extra steps of creating them separately.
Removed Unnecessary Business Columns
To delete unnecessary business columns...
- In the Business Table Properties dialog box navigation pane, select the column you want to remove.
- Click (Delete Column). The column you selected is removed from the list.
- Repeat Steps 1 and 2 with the remaining columns you want to delete.
- Click OK when you are done.