Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation


A fact or dimension table.


Attribute Data Type Definition
name String

The name of the table

schema String

Optional qualifier for table

alias String

Alias 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

Element Definition
SQL The SQL WHERE clause expression to be appended to any select statement
AggExclude Exclude a candidate aggregate table by name or pattern matching
AggTable A definition of an aggregate table for a base fact table.