Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at


Hitachi Vantara Lumada and Pentaho Documentation


Parent article

A fact or dimension table.


AttributeData TypeDefinition
nameStringThe name of the table
schemaStringOptional qualifier for table
aliasStringAlias to be used with this table when it is used to form queries. If not specified, defaults to the table name, but in any case, must be unique within the schema. You can use the same table in different hierarchies, but it must have different aliases.

Constituent Elements

SQLThe SQL WHERE clause expression to be appended to any select statement
AggExcludeExclude a candidate aggregate table by name or pattern matching
AggTableA definition of an aggregate table for a base fact table.