Skip to main content
Pentaho Documentation

Custom Properties

You can define any number of custom properties. You must give your property an ID to set its type.

  • String
  • Date
  • Numeric Value
  • Color
  • Font
  • Type of Field
  • Type of Aggregation
  • Boolean
  • Field Data Type
  • Localized String
  • Type of Table
  • URL
  • Security
  • Text Alignment
  • Column Width

Custom Table Joins

You can also use a custom property to create table joins in Metadata Editor. To do this, you must define the custom property as path_build_method with a valid value.

 

Table 1. Valid Values for Custom Table Joins
Value Description
ALL Use all tables and joins.
ANY_RELEVANT Use all joins that lead to any used table even if there is more than one path.
CLASSIC Use the old generation method.
FIRST_SHORT Returns the first path that only contains no duplicate joins between tables.
LOWEST_SCORE Returns a path that chooses all joins that will create the smallest score based on the estimated size of a table.
SHORTEST (Default) Returns a path connecting every required table with the smallest number of joins.

 

The generator defaults to SHORTEST if the property is not found in the model.

If this is determined to be too risky, then a Boolean value can be toggled in SqlGenerator or SQLGenerator to preferClassicShortestPath when set to true. Both classes will use CLASSIC if no setting is found in the model.