02. Metadata Properties Reference
Out-of-the-Box Properties
The table below shows the properties that are provided with Pentaho Metadata Editor.
Id |
Description |
Category |
Values |
---|---|---|---|
Name * |
This property describes the display name for the business object. |
General |
Alphanumeric |
Description * |
A descriptive text entry describing the business object. |
General |
Alphanumeric |
Comments * |
Additional comments regarding the business object. |
General |
Alphanumeric |
Security Information |
Security rules for granting/restricting access to the business object. |
General |
Determined by security widget; see Adding Security. |
Font |
The font properties to apply to this business object. |
Formatting |
Determined by font dialog |
Color of Text |
The foreground or text color for the business object. |
Formatting |
Determined by color dialog |
Text Alignment |
The text alignment for the business object. |
Formatting |
( Left | Right | Centered | Justified ) |
Color of Background |
The background color for the business object. |
Formatting |
Determined by color dialog |
Relative Size |
This property is normally associated with business tables and is used to calculate join paths. The sum of all table relative sizes in a path are calculated when deciding on a multi-table join, and the multi-table join with the smallest summed value is used for the join path. |
Formatting |
Numeric |
Aggregation Rule |
Determines the method of aggregating the data from this business object. |
Model Descriptors |
( None | Sum | Count | Distinct Count | Minimum | Maximum ) |
Data Type |
Data type for this business object. |
Model Descriptors |
( Unknown | String | Date | Boolean | Numeric | Binary | Image | URL ) + Length and Precision (Integers) |
Field Type |
What type or relationship purpose this field serves. |
Model Descriptors |
( Other | Dimension | Fact | Key | Attribute ) |
Table Type |
Table type is used to automatically determine relationship types with other tables. For instance, if a Fact table is joined with a Dimension table, this is normally an N to 1 relationship |
Model Descriptors |
( Other | Dimension | Fact ) |
Formula |
This property allows you to create a calculation defining the business object. See Pentaho Metadata Formulas for more information. |
Calculation |
Alphanumeric |
Is the Formula Exact? |
Determines whether the formula should be parsed as a Metadata Formula. If false, this field is treated as a database column name . |
Calculation |
Boolean |
Column Width |
The width of the column as represented for display. |
Miscellaneous |
( Pixels | Percent of Page Width | Inches | Centimeters | Points ) + Integer |
Hidden For the User? |
This hides the object from being displayed in the Business View of the model. |
Miscellaneous |
Boolean |
Mask for Number or Date |
The format mask that should be used when the data for this object is displayed. For dates, the format follows the date/time patterns for a Java SimpleDateFormat format mask. For numbers, the pattern should follow the Java DecimalFormat format mask. |
Miscellaneous |
Alphanumeric |
Target Schema |
This property defines the database schema to use when querying the business object. |
Miscellaneous |
Alphanumeric |
Target Table |
This property defines the physical database table from which the business object is defined. |
Miscellaneous |
Alphanumeric |
* Localized properties.
Custom Properties
You can define any number of custom properties. You must give your property an id and set its type.
The available types are:
- 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
Required Properties per Business Object
The table below shows required properties for given business objects. Required properties cannot be deleted.
Id |
PhysicalTable |
PhysicalColumn |
BusinessCategory |
BusinessModel |
---|---|---|---|---|
Name |
|
|
|
|
Description |
|
|
|
|
Security Information |
|
|
|
|
Table Type |
|
|
|
|
Relative Size |
|
|
|
|
Formula |
|
|
|
|
Field Type |
|
|
|
|
Data Type |
|
|
|
|
Aggregation rule |
|
|
|
|
Is the Formula Exact? |
|
|
|
|
Hidden for the User? |
|
|
|
|
Font |
|
|
|
|
Mask for Number or Date |
|
|
|
|
Color of Text |
|
|
|
|
Color of Background |
|
|
|
|