Add business tables and columns

Pentaho Metadata Editor

Part Number
After you create a business model, you must add the business tables and business columns. Then, you need to 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 Metadata Editor 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 Metadata Editor Graph.
Metadata Editor Graph, PME

Perform the following steps to create business tables and columns:

  1. Right-click Business Tables in the navigation pane or inside the Metadata Editor Graph workspace, and select Business Tables. You can drag a physical table from the navigation pane to the Metadata Editor Graph workspace to create a new business table based on that physical table.
    For example, the Customers business table was created by dragging the CUSTOMERS physical table as shown above. You can also drag the physical table in the navigation pane to the Business Tables node to create a new business table based on that physical table.
    A list of physical tables will appear, prefixed by the connection name to which they belong.
  2. Select the physical table you want associated with the new business table.
  3. 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.

    Business Table Properties dialog box
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.