Hitachi Vantara Pentaho Community Wiki
Child pages
  • 04. Creating Business Tables and Columns

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. Right-click (or ALT-click) on the Business Tables branch in the Navigator Tree.
  2. Select the New Business Table... option from the popup menu.
  3. You will be prompted with a list of physical tables, each prefixed by the connection name they belong to. Select the physical table you want to associate with this new business table.
    titleUnder Construction Alert

    The first business table you create determines what connection is linked to this model - the one connection that this model can support. The connection is determined by interrogating the physical table that you associate in this step.

    We will be building out the connection to business model UI functionality in the future, but realize for now (as of the M4 release) that this area is half-baked. If you change your mind and want to associate a different connection with this model, you will have to delete all of your business tables. You could possibly hand-edit the exported XML and re-import it to change the connection, but I haven't tried it so I won't guarantee that it will work.

  4. Click OK on the prompt. The Business Table Properties dialog displays.

Image Added

In the Business Table Properties dialog, you will notice the Name/ID field at the top of the dialog is pre-populated with a value. This is the id of this business table, and MUST be unique. We recommend that you accept the defualt value for this field.

The table you chose in step 3 is listed next, then below the fields is another Tree Navigator, 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.

To trim unnecessary business columns at this time:

Editor Graph: Creating a New Business Table