...
In earlier versions of Pentaho Metadata Editor, (prior to 2009/08/1501), aggregation functions had to be specified explicitly and the aggregation rule had to be selected. This is no longer necessary; the query that is generated will use the selected aggregation rule during execution. See Defining the Physical Column Aggregations for more information.
Multi-table expressions: Formulas can use any business column in the model
...
For example suppose we have 2 two business tables:
- Orders (fact table), ID=BT_ORDER_FACT
- Product (dimension), ID=BT_PRODUCT
...