Skip to main content
Pentaho Documentation

Advanced Functions

The Advanced category contains functions that deal with developer-centric actions.

Function Name Purpose
Message Format Formats text according to the Java Message Format specification.
Resource Message Format Formats text from a resource bundle according to the Java Message Format specification.
Lookup Maps a string from one column to another string. The possible mappings are given as (key, text) pairs. If the string from the column is null or matches none of the defined keys, a fallback value is returned.
Indirect Lookup Returns a value from a mapped field. The field's value is used as a key to the field-mapping. The expression maps the value to a new column name and returns the value read from this column.
Resource Bundle Lookup Performs a resource-bundle lookup using the value from the defined field as a key in the resource bundle. This expression behaves like a resource field.
Open Formula Enables you to create your own custom OpenFormula function using the built-in Formula Editor. This function will run before any other action in the report.